Word select from a string

[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

 

[mangesh_yadav]

Can you give an example.

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

Manges

 

[bridgjr]

Thanks Mangesh, that does what I want

 

[mangesh_yadav]

Well thats good.
Thanks for the feedback.

Manges