Get Last Word
String is in Cell A1
=RIGHT(A1,LEN(A1)-FIND("^^",SUBSTITUTE(A1," ","^^",LEN(A1)-LEN(SUBSTITUTE(A1," ","")))))
© Copyright
andrewsexceltips.net
All Rights Reserved.