Cleaning Messy Data

J

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.
 
P

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
 
Top