On Fri, 9 Sep 2005 13:36:37 +0100, "Pat" wrote:

anyone know if there is a formula that can return the first word of a string

example: 1

Abelia grandiflora 'Sherwoodii'

return - Abelia

example: 2

Abies balsamea

return - Abies

example: 3

Abutilon

return - Abutilon


what is needed is one formula that will cover all string possibilities

Thnkyou if you can help.



=LEFT(A1,FIND(" ",A1&" ")-1)

(will also work on the last example)


--ron