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

  • Thread starter Thread starter dhcruz
  • Start date Start date
D

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
 
=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
 
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
 
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
 
Rather than importing both columns and deleting the first, it's easier to
tell it "Do not import column (skip)" for the first column.
 
Good point David :-)

Richard


David said:
Rather than importing both columns and deleting the first, it's easier to
tell it "Do not import column (skip)" for the first column.
Click to expand...
 
Back
Top