Thread: Unwanted spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Loren Loren is offline
external usenet poster
 
Posts: 19
Default Unwanted spaces

I copy data from a different program and paste it into a spreadsheet and some
of the cells have unused spaces behind the last character. When I link that
data into the cell I want to post it into, it does not center with those 8 or
10 spaces. How do I format my destination cell so it will automatically
remove those spaces? I.E data now = (3/15/07 10:24:30 )
and I want it like (3/15/07 10:24:30)
--
Loren