| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Extracting First Name
Hello,
I was able to extract the Last Name from a string, however I am having difficulties extracting the First Name, especially when there is a Middle Initial involved. Example: Bond, James P. I just need to extract "James". Here is my formula I used for extracting the Last Name - =UPPER(IF(ISNUMBER(FIND(",",A1)),TRIM(LEFT(A1,FIND (",",A1)-1)),TRIM(LEFT(A1,FIND(" ",A1)-1)))) Thanks Ruan |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| extracting numbers from alphanumeric cells | Excel Worksheet Functions | |||
| Extracting information from records to another sheet automatically | Excel Worksheet Functions | |||
| Extracting data from Pivot | Excel Discussion (Misc queries) | |||
| Extracting info from word and displaying in an excel spreadsheet | Excel Discussion (Misc queries) | |||
| Extracting Values on one list and not another | Excel Discussion (Misc queries) | |||
Threaded Mode
