You can do it with
datatext to columnseasy
or look in the help index for
FIND


--
Don Guillett
SalesAid Software

"TimR" wrote in message
...
I have a list of about 4000 names...however...the names, both first and
last, are all in one column as follows: column A = lastname1, firstname1.
What I need to do is copy all the last names in column A and insert them
in
the adjacent cells in column B. I then would have a worksheet of names
as
follows:

A B
row 1 - firstname1 - lastname1
row 2 - firstname2 - lastname2
etc

In essence...I need to edit each cell, copy the text before the "," copy
or
move that to the adjacent cell and delete the , and the text (name) that
came before it in column 1

How can this be done...thanks, Tim