To clean the data there are a couple of things you want to do. Before you
start make a copy of the column you are about to play with in case something
goes wrong. Do a find and replace on the # symbol to remove all instances of
that. This can also be done with a formula but it is a lot trickier. Let me
know if you need that. Now you can deal with the remaining numbers. You can
split up the numbers using the Text to Columns function on the data menu.
Just select Fixed Length and place a divider after the 6th digit. You can
also do this with formulas if you want but again it is a lot trickier...

HTH

"Duncan_J" wrote:

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