ooops!

Sorry David..........missed your identical post.

Little slow after a big meal.


Gord

On Fri, 09 Feb 2007 19:27:17 -0800, Gord Dibben <gorddibbATshawDOTca wrote:

Tim

My method using DataText to Columns.

First select the column of names the EditReplace

What: space
With: nothing

Replace all.

Then with column selected, DataText to ColumnsDelimitedNextCommaFinish.

Select the B column header and slide mouse pointer down to edge of B1 to get a
4-headed pointer.

Hold SHIFT and move column B to the left and drop it.

Column A will shift right and you're done.


Gord Dibben MS Excel MVP

On Fri, 9 Feb 2007 18:06:36 -0700, "TimR" wrote:

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