Is it possible to separate a name in one cell such as John Smith in A1
to John in cell B1 and Smith in cell C1.

I read that by entering =LEFT(A1,FIND("",A1)) into B1 and
=MID(A1,FIND("",A1)+1,LEN(A1)) into C1 that would do it. However that
returns “J” in cell B1 and “ohn Smith” in C1

Specifying the number of characters for the first string would not work
on a list of names were the first string varies in length, so you need a
formula that takes everything before the first space as the first
string. Is it possible?


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=482289

Quaisne

You need a space between your occurrences of "", so " "

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"Quaisne" wrote in
message ...

Is it possible to separate a name in one cell such as John Smith in A1
to John in cell B1 and Smith in cell C1.

I read that by entering =LEFT(A1,FIND("",A1)) into B1 and
=MID(A1,FIND("",A1)+1,LEN(A1)) into C1 that would do it. However that
returns “J” in cell B1 and “ohn Smith” in C1

Specifying the number of characters for the first string would not work
on a list of names were the first string varies in length, so you need a
formula that takes everything before the first space as the first
string. Is it possible?


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile:
http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=482289

So simple yet it makes the difference. Thanks for that.


--
Quaisne
------------------------------------------------------------------------
Quaisne's Profile: http://www.excelforum.com/member.php...o&userid=28052
View this thread: http://www.excelforum.com/showthread...hreadid=482289