HELP - EASY

[moosemessier]

hi.

i am new. i want to ask someone the functions used for string extraction. i am using excel2000 and have a question.

i am manipulating data in a spreadsheet. i want to learn how to extract a last name at the end of a string and swap with the first.

ex.

William H. Dunham

i used the left,right,search functions but cannot extract dunaham becuase of multiple blanks.

ex - (RIGHT(A2,SEARCH(" ",A2))

returns- . Dunham

because the search is reading left to right and not right to left.

help!?

thanks soooooooo much.

 

[moosemessier]

ttt

 

[Aladin Akyurek]

On 2002-03-05 09:34, moosemessier wrote:
no it does:

j, dunham, mike

If you want me to send you the WB containing the formula, drop me an email.
This message was edited by Aladin Akyurek on 2002-03-05 10:55

 

[moosemessier]

aladin is the man. brilliant. thanks again man. it does work perfectly...........