Separating data in a cell

[chellegar]

How do I separate the data in a cell.

Example: Cell A1 contains First Names & Last Names. I want to separate the
first name and the last name. What formula should I use for that?

Thank you for your help!

[Gary's Student]

What separates the first and last names?
--
Gary's Student


"chellegar" wrote:

> How do I separate the data in a cell.
>
> Example: Cell A1 contains First Names & Last Names. I want to separate the
> first name and the last name. What formula should I use for that?
>
> Thank you for your help!

[JE McGimpsey]

One way (not using a formula):

Select Data/Text to Columns. Choose Delimited. Click Next. Click Space.
Click Finish.

(using a formula):

A1: Jane Doe
A2: =LEFT(A1,FIND(" ",A1)-1) ===> Jane
A3: =MID(A1, FIND(" ",A1)+1,255) ===> Doe



In article <56D90FED-4833-4281-8AAA-59B3B504DE6A@microsoft.com>,
chellegar <chellegar@discussions.microsoft.com> wrote:

> How do I separate the data in a cell.
>
> Example: Cell A1 contains First Names & Last Names. I want to separate the
> first name and the last name. What formula should I use for that?
>
> Thank you for your help!

[chellegar]

What about if there is a middle initial? Ex. Jane A. Doe

What will be the formula so that the middle initial will be included?

Thank you for the help!

"JE McGimpsey" wrote:

> One way (not using a formula):
>
> Select Data/Text to Columns. Choose Delimited. Click Next. Click Space.
> Click Finish.
>
> (using a formula):
>
> A1: Jane Doe
> A2: =LEFT(A1,FIND(" ",A1)-1) ===> Jane
> A3: =MID(A1, FIND(" ",A1)+1,255) ===> Doe
>
>
>
> In article <56D90FED-4833-4281-8AAA-59B3B504DE6A@microsoft.com>,
> chellegar <chellegar@discussions.microsoft.com> wrote:
>
> > How do I separate the data in a cell.
> >
> > Example: Cell A1 contains First Names & Last Names. I want to separate the
> > first name and the last name. What formula should I use for that?
> >
> > Thank you for your help!
>

[JE McGimpsey]

Always better if you specify what you want in advance, so that the
question only has to be answered once.

You don't say where you want the middle initial to be included...

If with the first name, one way:

=LEFT(A1,FIND(".",A1)+1)

In article <1ED15188-ABD1-4380-A282-20742F46C7E8@microsoft.com>,
chellegar <chellegar@discussions.microsoft.com> wrote:

> What about if there is a middle initial? Ex. Jane A. Doe
>
> What will be the formula so that the middle initial will be included?