View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Access Joe
 
Posts: n/a
Default Remove varying amounts of space characters

Thank you Ken. This works great

"Ken Johnson" wrote:

CLEAN doesn't remove spaces so you will also have to use TRIM which
removes all spaces except for single spaces that are between other
characters.
Ken Johnson