Excel File Opener - Embedded New Lines

[bsolove]

I am using the Excel File Opener Macro to input a bunch of different excel files at once (they are all in the exact same format).  Right off the bat, one of my columns contains the "this cell has embedded newlines warning.  I've tried several solutions that I found online, but nothing seems to work.  I am not even clear on what these means.  Please help!

[MarqueeCrew · Accepted solution]

Try this to replace the new lines with a space:

Regex_Replace([field],"\n",' ')

Cheers,

Mark