Thread: Separating Text strings.

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

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS


"Quaisne" <Quaisne.1xzjcb_1131129302.493@excelforum-nospam.com> wrote in
message news:Quaisne.1xzjcb_1131129302.493@excelforum-nospam.com...
>
> 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.