Help with Multiple Rows od data in one Excel Cell

[BKolosiw]

I have a data set form our CRM and sometimes and agent with type into our Case Descritpion field.  When they type, they will sometimes hit enter to create another line in that field.  When I extract the data, that Cell in excel will have multiple lines.  I need to delete that random cells that have those multiple lines within thew data.  Can anyone help me with that?  Thank you!

[JohnJPS · Accepted solution]

Hi @BKolosiw,

If you run it through the "Data Cleansing" tool, first thing after input, it can remove new line characters for you.  Could you try that to see if it works?

[RodL]

Dang! @JohnJPS beat me to it and with a much better solution than I was thinking of. (I keep forgetting about the Data Cleansing tool...it does SO much.)

As an inside joke with John, I was actually going to suggest RegEx with a Multi-Field Formula tool for the applicable fields with... REGEX_Replace([_CurrentField_], "\n", "")

And John went with the easier "less code" approach.

[BKolosiw]

@JohnJPS
Thank you, I was definitely trying to over complicate it. You help is much
appreciated!

--
Bk

[BKolosiw]

Both were very helpful!  Thank you!!!