Usually in a list of names, I frequently need to find the last word in a
field, i.e., locate the last space. Is there any way of doing this with
formulas alone or must I resort to VBA?


--
clearwaterdave
------------------------------------------------------------------------
clearwaterdave's Profile: http://www.excelforum.com/member.php...o&userid=19365
View this thread: http://www.excelforum.com/showthread...hreadid=565801