Prev: Date Math
Next: Picture protection
From: digileaf on 27 May 2010 07:50

The clean function in Excel sorts this out perfectly.

Lets say your string with these funny characters is in cell A5, then in
the adjacent cell type =CLEAN(A5) and you'll get the string without the
funny characters in there.

It's brilliant and so simple.

Kate


--
digileaf
------------------------------------------------------------------------
digileaf's Profile: http://www.thecodecage.com/forumz/member.php?u=1935
View this thread: http://www.thecodecage.com/forumz/showthread.php?t=189650

http://www.thecodecage.com/forumz

 | 
Pages: 1
Prev: Date Math
Next: Picture protection