I have a spreadsheet with an imported list of employee numbers . The problem
is there are letters attached to the employee numbers signifying the
particular job the employee completed.
A C
PF44250 Bill Smith
BA85460 John Doe
AB87654 Jim Moore

I was wondering if there are wild cards that I can build into a formula that
will allow me to ignore the letters . I could use Vlookup to produce the
employees name which is what I need in column C.

Thank you in advance for any help you can provide