Cleaning Messy Data

  • Thread starter Thread starter Jay
  • Start date Start date
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.
 
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
 
Back
Top