Thread: Removing Spaces
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Gary Gary is offline
external usenet poster
 
Posts: 273
Default Removing Spaces

Hello,

I have an Excel Spreadsheet that has a column that lists 100s of song titles
but the first charactor in each cell in this column is a space.

Is there a way of removing these spaces automatically?

Many thanks
Gary