Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using FIND function to locate space between first and last name
Hello,
I am trying to extract last names out of a list of doctors formated as first name, last name, then MD. I am trying to use the find function to count the characters up to the space between the names using =FIND(" ",A1) but I get a value error. Is there any way to find the position of a space? Or is it possible to count up to the second upper case letter in the string which would give me the start of the last name? Thanks in advance for answering this newbie question! Dennis |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using FIND function to locate space between first and last name
Assuming that the data is in the following format...
John Doe, MD ....try the following formula... =MID(A1,FIND(" ",A1)+1,FIND(",",A1)-FIND(" ",A1)-1) Hope this helps! In article . com, "Dennis_in_nh" wrote: Hello, I am trying to extract last names out of a list of doctors formated as first name, last name, then MD. I am trying to use the find function to count the characters up to the space between the names using =FIND(" ",A1) but I get a value error. Is there any way to find the position of a space? Or is it possible to count up to the second upper case letter in the string which would give me the start of the last name? Thanks in advance for answering this newbie question! Dennis |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|