I figured it out, I used an "IF" with "ISTEXT" to test the cell first.
Thanks for all the help.

Mike Rogers

"Mike Rogers" wrote:

Biff

Works like you knew it would. I knew I had to look for the second space but
never would have figured that out. I will study it and try to figure out the
)+1)+1,1)) stuff. Thanks a million for the help!!!

Mike Rogers

"Biff" wrote:

Hi!

Try this:

=UPPER(LEFT(A1)&MID(A1,FIND(" ",A1)+1,1)&MID(A1,FIND(" ",A1,FIND("
",A1)+1)+1,1))

Biff

"Mike Rogers" wrote in message
...
I am trying to figure out how to extract intials from a name.
The names are in one column in the format of "Frank A Right". I have the
first initial extracted and the middle initial extracted, but I can't seem
to
get the first letter of the last name. So far I have:
=UPPER(LEFT(A1,1)&MID(A1,FIND(" ",A1)+1,1)). What would I add to this to
get
the last initial?

Thanks
Mike Rogers