Hi

To separate one column in 2. Assuming Column A contains Lastname,
firstname. Column B must be empty if not insert a column to create and
empty columnB.

Once completed click on column A (this should highlight Columns), from
there go to menu ----Data ----Text to Columns... Choose the option
Delimited and then click on next choose the option space. Click on
next and then finish and everything should be separated into 2
columns.

THanks
Denis


--
jetted
------------------------------------------------------------------------
jetted's Profile: http://www.excelforum.com/member.php...o&userid=17532
View this thread: http://www.excelforum.com/showthread...hreadid=558631