Good point David :-)

Richard


David Biddulph wrote:

Rather than importing both columns and deleting the first, it's easier to
tell it "Do not import column (skip)" for the first column.
--
David Biddulph

"RichardSchollar" wrote in message
ups.com...
An alternative would be to use DataTextToColumns, check Fixed Width
and set a column separator on the second character. You'd then need to
delete the first column, leaving the contents without the first
character.

Richard

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