View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
STRAC STRAC is offline
external usenet poster
 
Posts: 13
Default Removing a leading space in a numbered currency cell

I have a spreadsheet which was imported from another program. I want to
total up the currency columns but find that each cell contains a leading
space which prevents Excel from doing an auto sum on the column. How do I
delete the leading space without having to go into each individual cell (2000
plus) and delte the space?