On Sat, 23 May 2009 05:26:01 -0700, Nev wrote:

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


=LEFT(A1,FIND(CHAR(10),A1)-1)

CHAR(10) is the LineFeed character; which should be at the end of the first
line.
--ron