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