pls try this :

if u r removing character should be same in ur 600 line then only my answer
will work if there is any diff it won't work full..

use FIND & REPLACE option
go to Replace ........... find place type u r first character
replace with ___________ dont type
empty u leave
click replace all......... so all u r find character should be empty ........

maybe this will help u

try..........

" 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