How to remove (delete) the first Character in all of the columns

[dhcruz]

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

 

[Guest]

=RIGHT(A1,LEN(A1)-1)
copy down as far as needed

or

Select your range
Go to Edit > Replace
Find What: 1
Replace With: (leave it blank)
Replace All

 

[RichardSchollar]

An alternative would be to use Data>TextToColumns, 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

 

[Pete_UK]

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

 

[David Biddulph]

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

 

[Dave Peterson]

But be careful if there are other 1's in any of those cells.

 

[RichardSchollar]

Good point David

Richard

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