Hi guys,

I have to get the last word from text cell.

For example,

Mr. and Mrs. Smith

I need to get Smith. The number of words is changeable.

Thanks a lot in advance,

Irina.


--
Irina
------------------------------------------------------------------------
Irina's Profile: http://www.excelforum.com/member.php...fo&userid=8685
View this thread: http://www.excelforum.com/showthread...hreadid=501197