View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Tom Tom is offline
external usenet poster
 
Posts: 17
Default Removing spaces in cell

Hello,

When importing external data into excel, I end up with 2 blank spaces
before the data. Need to remove the 2 blanks spaces for all the cells
in that column. Changed the format and tried decreasing indent,
neither worked.

Is there a formula or VBA code that would work?

Thanks,
Tom