Removing of preleading character in a cell

  • Thread starter Thread starter inktec
  • Start date Start date
I

inktec

Hi, I am currently working on a price list that involves large amount
of product codes in one column, descriptions in another column, price
in another etc.

In my product code column, I want to remove the first letter from th
product code e.g. H51645A to 51645A. Can I run a formula to remove thi
automatically as I do not have the patience to sit and manually remov
the first letter from 2000 codes.

In addition, how do you remove pre-leading 0 from a numeric code? i.e
01011450 to 1011450.

Excel Version 2000, Version 9

Thanks,

Botswan
 
In my product code column, I want to remove the first letter from the
product code e.g. H51645A to 51645A. Can I run a formula ...
Click to expand...

Insert a column to the side of the codes column as a helper. Use e.g.

=RIGHT(D1,LEN(D1)-1)

and drag down to row 2000.

Select & copy the helper column, then Edit -- Paste Special -- Values.

Delete the original codes column.

Rgds,
Andy
 
In addition, how do you remove pre-leading 0 from a numeric code? i.e.
01011450 to 1011450.
Click to expand...

Sorry, forgot that bit. Might be formatted as text. Put a 1 in a free cell
and copy it. Then select the numeric codes range & Edit -- Paste Special --
Multiply.

Rgds,
Andy
 
Inktec

This will turn your text into numbers. If you use them for other functions
these might no longer work. If it is a number already, change the custom
format for the cell. If it is text, you can use the first answer Andy gave
you for this too.

Andy.
 
Back
Top