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

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