Thread: Removing Space
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
KL Cheong
 
Posts: n/a
Default Removing Space

Hi,

I have a list of part number (consist of either 8 or 14 characters) in one
column. However, I notice that each of them are ended with a space after the
last character. Any idea of how to remove the space in a smart way. I have
thousand of lines wonder when I can have all the space removed if going one
by one?