One way
=LEFT(D19,FIND(" ",D19,FIND(" ",D19)+1)-FIND(" ",D19))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Nev" wrote in message
...
I have an address
Any place
Anywhere
UK
in the above format. I want to be be to copy the first line into another
cell. I have found first word but some places have 2 names or even 3.

Can anyone help? I need to do this with a formula and not vba.

thanks

Nev