Try this:
=LEFT(A1,FIND(" ",A1,1)-1)
"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.
|