Thread: =clean(a1)
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mark Bigelow Mark Bigelow is offline
external usenet poster
 
Posts: 55
Default =clean(a1)

Try this:

strTest = Replace(TESTchar(27)TEST1char(7)TEST2, char(27), " ")

strTest = Replace(strTest, char(7), " ")

Let me know if that doesn't work.

Mark
---
Mark Bigelow
mjbigelow at hotmail dot com
http://hm.imperialoiltx.com

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!