Is there a way to parse out the first line of a paragraph from an excel cell?

[wonka1234]

Hi,

Say I have cells like this -

Paragraph C1 - C33 of the Document
Blah blah blah blah

Can I parse out the first like of the paragraph so I only get :

Paragraph C1 - C33 of the Document

[DataNath · Accepted solution]

@wonka1234 if it's always just the first line then you'll be able to use a Formula tool with this expression:

REGEX_Replace([Input], '([^\n]+)\n.*', '$1')

Which just isolates everything before the first instance of a line break.

[csmith11]

You can parse the column using text to column tool. The delimiter you want to use is \n. This will push the first line into the first column and then you can deselect any subsequent columns.

[binuacs]

@wonka1234 One way of doing this