Issue with formatting - need to convert LINE FEEDS into SEMI-COLON (or other character)

[MattDay2u]

I have an issue where a vendor copied address entries into a field; however, where I saw line feeds in the original address format, the output became runon.
For instance:
400 George Street
Brisbane, QLD 4000

...became...
400 George StreetBrisbane, QLD 4000

I have thousands of entries line that. If I can convert the line feeds into something like a character, I could then use DATA/TEXT TO COLUMNS to delimit the data accordingly.
Many thanks in advance.

[Glenn Kennedy]

Are you sure that the LFs are gone? Is text wrapping on?? Can you post a small sample excel sheet?


Unfortunately the attachment icon doesn't work at the moment. So, to attach an Excel file you have to do the following: Just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

[MattDay2u]

Sorted Used Substitute function

[AliGW]

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.