View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
bnkone
 
Posts: n/a
Default Removing leading 0s

I have a sheet of 10K+ rows that have entries like this: 000345, 0034567,
0000067 etc. I am trying to do a vlookup on another table of +10K rows and
join on the numbers. Unfortunately one of my source tables is missing the
leading 0's with no hope of fixing it. Can anyone help me with a way to
remove the leading 0's?