View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
NunRacer NunRacer is offline
external usenet poster
 
Posts: 6
Default Extract specific text

I've tried searching for some solutions to my problem but havnt found
anything that really helps me.

I want to extract a persons name (the name is mixed up with other useless
info, and doesnt follow the same format) from a cell that matches the names i
have in a Database.

so example would be
3-PKR11500 TGDL1 TAYLOR, GEORGE 15:00 - 23:00 x
3-SP12300 TGDS2 BLOW, JOE 23:00 - 7:00 x
So i need a formula to pull the name out by comparing it to the existing
names in the database.
The end result needs to be just their name.
Thank You.