MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Spliting one column into two?

Posted by Kendal Nichols on January 25, 2002 8:29 AM

I have a column with full names (Ex. Nichols, Kendal)

Is there a way to split this column into two columns, one with the first name, and one with the last.

Thanks for your help,

Posted by jon on January 25, 2002 8:36 AM

There may be an easier way, but this works.

jon scorey jon scorey
=LEFT(I455,FIND(" ",I455))
=RIGHT(I455,LEN(I455)-FIND(" ",I455))


Posted by Stephen Hoadley on January 25, 2002 10:39 AM

Highlight the column and the go to Data menu and use "text to columns" select delimited option and tik the space box click finish and there you have it

Hope it helps you out