Separate names into 2 columns?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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

.

Follow-Ups:
- Re: Separate names into 2 columns?
  - From: Hernandez, Roberto

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: building website
... > Can you build websites with Excel? ... Ltat42a ... Ltat42a's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=24735 ... Prev by Date: ...
(microsoft.public.excel.misc)