Using FIND function to locate space between first and last name

  • Thread starter Thread starter Dennis_in_nh
  • Start date Start date
D

Dennis_in_nh

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
 
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!
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Windows 10 I would like to know in a batch file how to indentify computer name by using the first 5 of the name and the last 2 of the name then call runcmd 0
Access to split First and Last name 0
Help finding the last space in a cell 2
Separate First Name MI and Last Name into three Cells 3
Find position number of third space 6
Function similar to "LEFT" 3
Find last space 3
Separate first name, middle name and last name 2

Back
Top