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.
|