Thread: How can I delete unprintable characters using VBA in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
K Dales[_2_] K Dales[_2_] is offline
external usenet poster
  
Posts: 1,163
Default How can I delete unprintable characters using VBA in Excel?
Use WorksheetFunction.Clean(YourString) - for example, if you wanted to clean
the text in cell A3 you would have:
Range("A3").Value = WorksheetFunction.Clean(Range("A3").Value)
--
- K Dales


"peterv" wrote:


I want to delete unprintable characters in an Excel sheet using VBA.
I've tried using the CLEAN function, but can't find the correct syntax
to get it to work in VBA. Can anyone help?
Thanks!


--
peterv
------------------------------------------------------------------------
peterv's Profile: http://www.excelforum.com/member.php...o&userid=25572
View this thread: http://www.excelforum.com/showthread...hreadid=471435


Reply With QuoteReply With Quote