Another way is to highlight the offending cells and then use
Edit/Replace (CTRL-H) to find 1 and replace it with nothing.

Hope this helps.

Pete

wrote:

Hi,

How do you remove the first character from all of the columns in an
excel spreadsheet ?
In the column below - I would want to remove all of the leading 1's.
There are over 600 rows in the column.

Thanks !!

ex:

1dan
1bill
1dill
1sill
1dan
1bill
1dill
1sill