I wish to select a particular word from a string but cannot see a
formula to do it. At the moment I am only interested in the first word
so coded
A1="FRED BLOGGS"
=LEFT(A1,FIND(" ",A1)-1)
which works fine as long as there is a " " in the string.
However this is not always the case so the FIND function returns
#VALUE! and messes up the the formatting.
I'm sure there is an easier way of doing this so any help would be
appreciated.
Many thanks.
--
bridgjr
------------------------------------------------------------------------
bridgjr's Profile:
http://www.excelforum.com/member.php...o&userid=25908
View this thread:
http://www.excelforum.com/showthread...hreadid=392844