CLEAN doesn't remove spaces. Presumably what you think are spaces are really
unprintable characters.

Dave
--
Brevity is the soul of wit.


"cassy269" wrote:


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