Thread: Clean Function
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
cassy269 cassy269 is offline
external usenet poster
 
Posts: 1
Default Clean Function


Hello - I need to "Clean" some data.

I have some nonprintable characters that I can use the clean function
to remove. However, when I remove them it also removes the space
between the two words in my text string. Is there a way to clean the
nonprintable characters and replace those characters with a space
character instead of nothing?


--
cassy269
------------------------------------------------------------------------
cassy269's Profile: http://www.officehelp.in/member.php?userid=6142
View this thread: http://www.officehelp.in/showthread.php?t=1323006

Posted from - http://www.officehelp.in