Thread: How can I delete unprintable characters using VBA in Excel?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default How can I delete unprintable characters using VBA in Excel?
See David McRitchie's TrimAll code.

http://www.mvps.org/dmcritchie/excel/join.htm#trimall


Gord Dibben Excel MVP


On Wed, 28 Sep 2005 10:18:17 -0500, 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!

Reply With QuoteReply With Quote