"Duncan_J" wrote in message
...
Hi,
I'm trying to do a vlookup in my macro. However spreadsheet one has 6
numbers and the other sheet adds # and letters after the 6 number. Is
thier
anyway to get rid of the # and letters after the sixth.
Example:
834543
834543R7

742351
74235112

Thanks,
DJ

If 834543R7 is in cell A1, you can enter =LEFT(A1,6) in column B and drag
the formula downwards. It will return 834543
Do a vlookup on column B

/Fredrik