You're welcome. Thanks for the feedback!

Biff

"ferde" wrote in message
...
Works Perfect!! Thank you so much for the quick reply

"T. Valko" wrote:

Try one of these:

D1 = 87654

=INDEX(B1:B3,MATCH("*"&D1,A1:A3,0))

=VLOOKUP("*"&D1,A1:B3,2,0)

Biff

"ferde" wrote in message
...
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