Hi

Take a look at Datatext to Columnsdelimitedcomma as separator.

--
Regards

Roger Govier


"Help" wrote in message
...
Ok here what I need to do. In column 1 I have five rows of names
first and
last names seperated by a comma.....example Smith, Joe (all in one
column).
I need to take the comma out and put Smith in column 1 and Joe in a
new
column or column 2 by itself. Therefore I need Smith (in Column A)
Joe (in
column B). Thanks for the help. Please give me step by step on how to
do this.