I'll give you some formulas to work with and see if they help. I have
separated the formulas so you can see what they do and then I put them all
together in cell A5 as one nested formula. Note that SEARCH is not case
sensitive. FIND is the same but is case sensitive.

SEARCH finds the start of the search text in the text being searched.
LEN returns the length of the search text
MID returns the search text from the start position for its length.

Cell A1: 3-PKR11500 TGDL1 TAYLOR, GEORGE 15:00 - 23:00 x
Cell A2: taylor, george
Cell A3: =SEARCH(A2,A1) this formula gives result 18
Cell A4: =LEN(A2) this formula gives result 14
Cell A5: =MID(A1,SEARCH(A2,A1),LEN(A2)) result is TAYLOR, GEORGE

Hope it helps.

Regards,

OssieMac



"NunRacer" wrote:

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.