Can I use the Substitute function to remove a line-break?

Hello!

I'm having success nesting the substitute function to remove multiple things from a field of text in a cell and replace them with a blank space. I would like to remove line-breaks/enter/return and replace them with a semicolon.

I'd like to turn something like this:

Meredith Rhodes, PhD

Into this:

Meredith Rhodes, PhD; Meredith Rhodes, PhD

Is there a way to do this?

Thank you!

Meredith

Find more posts tagged with

Formulas

Accepted answers

Linda Manduchova

Hello @Meredith Rhodes -

You can try the following formula, however, if you have multiple line-breaks, the formula will return multiple semicolons.

=SUBSTITUTE(Name@row, CHAR(10), "; ")

Linda

All comments

Linda Manduchova

Hello @Meredith Rhodes -

You can try the following formula, however, if you have multiple line-breaks, the formula will return multiple semicolons.

=SUBSTITUTE(Name@row, CHAR(10), "; ")

Linda

Meredith Rhodes

Thank you @Linda Manduchova! I can work with this.

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.