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

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 <1145472753.285408.34690@g10g2000cwb.googlegroups.com>,
"Dennis_in_nh" <dennis@NEBRACE.com> 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