you could possibly do it with SUBSTITUTE nested but why not just use vba?

--
Don Guillett
SalesAid Software

"clearwaterdave"
<clearwaterdave.2bmhvt_1154035508.7878@excelforu m-nospam.com wrote in
message news:clearwaterdave.2bmhvt_1154035508.7878@excelfo rum-nospam.com...

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