removing characters???

  • Thread starter Thread starter William Stokes
  • Start date Start date
W

William Stokes

Hello,
I need to edit one huge column in a excel file so that from each row in the
column last 6 characters are removed. How to do this? I have no idea...

Thanks a LOT
-Will
 
Hi!

Use a temporary helper column.

Assume column A contains the entries you want to change.

In column B enter this formula and copy down as needed:

=SUBSTITUTE(A1,RIGHT(A1,6),"")

After you have copied the formula inspect the results and make sure you got
what you wanted. Then select that range of formulas and:

Edit>Copy
Edit>Paste Special>Values>OK

Then you can delete the original column A if you want.

Biff
 
Thanks Biff,

I have Excel 2002 and I can't get this "RIGHT" part to work. So I can't
remove chars counting from the end. The Excel help doesn't know anything
about this "RIGHT" feature. Do you have an idea why? Othervise this formula
is just the thing

-Will
 
Hi!

RIGHT is a built-in function and should be available.

This will do the same thing:

=LEFT(A1,LEN(A1)-6)

Biff
 
Back
Top