HELP! get rid of the 0!

[nathan663]

I have a problem, i have two lists. One list is a list of numbers (all of which are 6 digits) the second list contains 7 digit numbers (all of these numbers start with 0) I am trying to do a vlookup but with this 0, i will not find anything, how can i make a new list from the 7 digit numbers but without the first digit in each number (ie get rid of the 0.)

Please note i some numbers may be 0000234. I only want to get rid of the first 0.

Regards

Nathan Gallichan

 

[Ketan]

Use this formula =MID(B3,FIND("0",B3,1)+1,15) .........where consideringyour data in b3.........here 15 is max digits.......you may change as per requirement

 

[Jaz05]

Hi Nathan663,

If this is straighforward vlookup (always looking up 6 digits) then use the following:

=VLOOKUP(RIGHT(A1,6),Sheet2!$A:$B,2,0)