Conditional Removal Of Numerals from Cell Value

Hi all,

I'm creating some workbooks from PDF files. After converting, some of the
values in column A get placed into column B along w/it's values.
Column A should have only a 6 digit number. Column B may have a combination of numbers and letters, but more use of letters.

I'm trying to create a formula for that will remove the 6 digit number at the front of my text values if it is present in column b. If it is not, than the column should remain the same. Is there a way to say remove first six values
from left if values are numbers? The results should out put to sheet 2.

VBA code would be nice but not necessary.

I've attached an example file.

Any help is appreciated.

Thanks,

bdb

In Sheet2 A10

Please Login or Register  to view this content.

In Sheet2 B10

Please Login or Register  to view this content.

This doesn't work for that oddball one you have in A39. I didn't notice that one until later. I can modify the code for that one if you need it.