Separate names into 2 columns?

I have a column of names (first & last name). Is it possible to separate them into two columns - 1 column for first name, next column for last name?

Thanx...JF

Yes.
Use the Menu Data--> Text to columns wizard....
And voila!

"Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com> escribió en
el mensaje news:Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com...
>
> I have a column of names (first & last name). Is it possible to separate
> them into two columns - 1 column for first name, next column for last
> name?
>
> Thanx...JF
>
>
> --
> Ltat42a
> ------------------------------------------------------------------------
> Ltat42a's Profile:
> http://www.excelforum.com/member.php...o&userid=24735
> View this thread: http://www.excelforum.com/showthread...hreadid=490866
>

I don't know if it is appropriate to bogart onto someone else's post but is
it possible to do this in reverse. That is take first and last name or First
name, spouse first name and Last name information from separate columns and
combine it into one column ie John & Jane Smith or John Smith

"Hernandez, Roberto" wrote:

> Yes.
> Use the Menu Data--> Text to columns wizard....
> And voila!
>
> "Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com> escribió en
> el mensaje news:Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com...
> >
> > I have a column of names (first & last name). Is it possible to separate
> > them into two columns - 1 column for first name, next column for last
> > name?
> >
> > Thanx...JF
> >
> >
> > --
> > Ltat42a
> > ------------------------------------------------------------------------
> > Ltat42a's Profile:
> > http://www.excelforum.com/member.php...o&userid=24735
> > View this thread: http://www.excelforum.com/showthread...hreadid=490866
> >
>
>
>

John in A1

Jane in B1

Smith in C1

In D1 enter =A1 & " & " & B1 & " " & C1

Returns John & Jane Smith


Gord Dibben Excel MVP

On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable"
<Ineluctable@discussions.microsoft.com> wrote:

>I don't know if it is appropriate to bogart onto someone else's post but is
>it possible to do this in reverse. That is take first and last name or First
>name, spouse first name and Last name information from separate columns and
>combine it into one column ie John & Jane Smith or John Smith
>
>"Hernandez, Roberto" wrote:
>
>> Yes.
>> Use the Menu Data--> Text to columns wizard....
>> And voila!
>>
>> "Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com> escribió en
>> el mensaje news:Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com...
>> >
>> > I have a column of names (first & last name). Is it possible to separate
>> > them into two columns - 1 column for first name, next column for last
>> > name?
>> >
>> > Thanx...JF
>> >
>> >
>> > --
>> > Ltat42a
>> > ------------------------------------------------------------------------
>> > Ltat42a's Profile:
>> > http://www.excelforum.com/member.php...o&userid=24735
>> > View this thread: http://www.excelforum.com/showthread...hreadid=490866
>> >
>>
>>
>>

Add in an IF statement and it works like a charm all in one column.

Thanks

"Gord Dibben" wrote:

> John in A1
>
> Jane in B1
>
> Smith in C1
>
> In D1 enter =A1 & " & " & B1 & " " & C1
>
> Returns John & Jane Smith
>
>
> Gord Dibben Excel MVP
>
> On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable"
> <Ineluctable@discussions.microsoft.com> wrote:
>
> >I don't know if it is appropriate to bogart onto someone else's post but is
> >it possible to do this in reverse. That is take first and last name or First
> >name, spouse first name and Last name information from separate columns and
> >combine it into one column ie John & Jane Smith or John Smith
> >
> >"Hernandez, Roberto" wrote:
> >
> >> Yes.
> >> Use the Menu Data--> Text to columns wizard....
> >> And voila!
> >>
> >> "Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com> escribió en
> >> el mensaje news:Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com...
> >> >
> >> > I have a column of names (first & last name). Is it possible to separate
> >> > them into two columns - 1 column for first name, next column for last
> >> > name?
> >> >
> >> > Thanx...JF
> >> >
> >> >
> >> > --
> >> > Ltat42a
> >> > ------------------------------------------------------------------------
> >> > Ltat42a's Profile:
> >> > http://www.excelforum.com/member.php...o&userid=24735
> >> > View this thread: http://www.excelforum.com/showthread...hreadid=490866
> >> >
> >>
> >>
> >>
>

?????

Gord

On Tue, 6 Dec 2005 13:56:04 -0800, "Ineluctable"
<Ineluctable@discussions.microsoft.com> wrote:

>Add in an IF statement and it works like a charm all in one column.
>
>Thanks
>
>"Gord Dibben" wrote:
>
>> John in A1
>>
>> Jane in B1
>>
>> Smith in C1
>>
>> In D1 enter =A1 & " & " & B1 & " " & C1
>>
>> Returns John & Jane Smith
>>
>>
>> Gord Dibben Excel MVP
>>
>> On Tue, 6 Dec 2005 12:16:03 -0800, "Ineluctable"
>> <Ineluctable@discussions.microsoft.com> wrote:
>>
>> >I don't know if it is appropriate to bogart onto someone else's post but is
>> >it possible to do this in reverse. That is take first and last name or First
>> >name, spouse first name and Last name information from separate columns and
>> >combine it into one column ie John & Jane Smith or John Smith
>> >
>> >"Hernandez, Roberto" wrote:
>> >
>> >> Yes.
>> >> Use the Menu Data--> Text to columns wizard....
>> >> And voila!
>> >>
>> >> "Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com> escribió en
>> >> el mensaje news:Ltat42a.1zl4hm_1133816100.9486@excelforum-nospam.com...
>> >> >
>> >> > I have a column of names (first & last name). Is it possible to separate
>> >> > them into two columns - 1 column for first name, next column for last
>> >> > name?
>> >> >
>> >> > Thanx...JF
>> >> >
>> >> >
>> >> > --
>> >> > Ltat42a
>> >> > ------------------------------------------------------------------------
>> >> > Ltat42a's Profile:
>> >> > http://www.excelforum.com/member.php...o&userid=24735
>> >> > View this thread: http://www.excelforum.com/showthread...hreadid=490866
>> >> >
>> >>
>> >>
>> >>
>>