Re: Separate names into 2 columns?

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

"Ltat42a" <Ltat42a.1zl4hm_1133816100.9486@xxxxxxxxxxxxxxxxxxxxx> escribió en
el mensaje news:Ltat42a.1zl4hm_1133816100.9486@xxxxxxxxxxxxxxxxxxxxxxxx
>
> 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?action=getinfo&userid=24735
> View this thread: http://www.excelforum.com/showthread.php?threadid=490866
>


.

Relevant Pages

  • soduko
    ... and columns with countif but need each separate box to show if they ... webby62's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24441 ... Prev by Date: ...
    (microsoft.public.excel.worksheet.functions)
  • Re: If Statement Overwhelm
    ... separate and formulas for two colors) ... duane's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=11624 ... Prev by Date: ...
    (microsoft.public.excel)
  • Separating a string to two fields
    ... I have a full name column that I need to separate. ... Maybe someone has a 4 year old child that could help ... asdf032's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=27041 ... Prev by Date: ...
    (microsoft.public.excel.programming)
  • Re: Excel - Hide Column/s or Change Font color Only for printing
    ... Separate them: ... Mangesh ... mangesh_yadav's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=10470 ... Prev by Date: ...
    (microsoft.public.excel.misc)
  • Re: Range varying in for loop
    ... You need to separate your variables and text fully with quotes and & ... bhofsetz's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=18807 ... Prev by Date: ...
    (microsoft.public.excel.programming)