Search...

[Mark]

Hello Microsoft Excel community.

I have an urgent problem that I need a quick solution to
(please!) -

Problem:

Cell C2 has a value of "Jones, C."
Cell D2 =search(" ",c2)
Returns "Jones"

Cell C3 has a value of "Smith"
Cell D3 =search(" ",c3)
Returns "#VALUE!

I wish to have just the last name returned regardless if
there is a middle initial or not - any ideas?

Thank you in advance

Mark

 

[Frank Kabel]

Hi
have a look at
http://www.cpearson.com/excel/FirstLast.htm