There are two way of removing spaces.

1) In the Edit Menu use replace and replace a space with nothing. This will
remove all spaces not just the one at the beginning of the line.

2) Add the formula below in a new column. Then use copy and paste special
(value only) to copy the data in the new column back to the original column.

=MID(A1,2,LEN(A1)) where A1 is the cell with the spaqce at the beginning.

"Gary" wrote:

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