M
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
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