Word select from a string

B

bridgjr

I wish to select a particular word from a string but cannot see
formula to do it. At the moment I am only interested in the first wor
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 return
#VALUE! and messes up the the formatting.

I'm sure there is an easier way of doing this so any help would b
appreciated.

Many thanks
 
M

mangesh_yadav

Can you give an example.

Or is this what you want.
=IF(ISERR(FIND(" ",A1)),A1,LEFT(A1,FIND(" ",A1)-1))

Manges
 
Top