Hi

Try Data/Text to columns. This should be able to split the names into
separate cells for you.
An alternative is to use something like this:
=MID(A2,FIND(" ",A2)+1,LEN(A2)-FIND(" ",A2))&" "&LEFT(A2,FIND(" ",A2)-1)
This will find the first <space in A2 and assume that it is the split
between the names. If you have middle names, or Mr or Mrs, it will be more
difficult than this, though.

Andy.

"britgirl" wrote in
message ...

Hi there,

I have created a database of names & addresses from a software program
called "CLIP" into excel, which in turn will become a label mail merge
in MS word consisting of 900-1000 customers (for a mass mailing).

The problem is, the names were created last, first and I would like to
change them to first last. Is there a way to do that without manually
typing them all in again?

The names are in one column, so I cannot just switch the columns
around.

Thanks for your help...


--
britgirl
------------------------------------------------------------------------
britgirl's Profile:
http://www.excelforum.com/member.php...o&userid=29957
View this thread: http://www.excelforum.com/showthread...hreadid=523529