Cleaning Messy Data

[Jay]

I’m trying to fix a messy imported data set. The CLEAN formula removes
unprintable characters, but also removes separation between multiple words.
Is there a way to replace unprintable characters with spaces or delimiters
such as commas? Thanks.

 

[Pete_UK]

You could use the SUBSTITUTE formula to replace some text (eg
character code 160) with some other text (eg space or comma, or both).
Further details can be found in Excel Help.

Hope this helps.

Pete

 

[CLR]

There's a bazillion tricks to cleaning messy data. ASAP Utilities, available
at www.asap-utilities.com can be very helpful here.

Vaya con Dios,
Chuck, CABGx3