Help with Multiple Rows od data in one Excel Cell

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!

Preparation

Accepted answers

JohnJPS

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?

All comments

JohnJPS

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. Smiley LOL

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!!!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703