Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Extract specific value using SEARCH FORMULA | Excel Worksheet Functions | |||
Extract value from Specific Cell | Excel Worksheet Functions | |||
Formula to extract a specific word from text string | Excel Worksheet Functions | |||
Extract specific value from a long text string | Excel Worksheet Functions | |||
Extract Specific Text | Excel Worksheet Functions |