View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
ssexcel[_8_] ssexcel[_8_] is offline
external usenet poster
 
Posts: 1
Default Deleting unwated control characters at the end in a particular column


Thanks Kevin, your code works fine.

The problem with CLEAN() is that it knocks off all the carriage returns
and the paragraph formatting is lost.

Thanks once again to everyone who wrote.

Another related question: If these boxes appear at the end of each and
every para (since they are carriage returns) how do I "catch" them ?

Regards


------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/