Reversing name format

G

Gerry

I want to reverese the order of a name
e.g in column A I have Gerard kelleher but I want it as
Kelleher Gerard how do I do this
 
K

Ken Wright

=MID(A1,FIND(" ",A1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1)-1)

Only works with two names though.
 
P

Paul Simmons

Well I'm sure there is a way to change this ider bassed on one cell, however
this will to work as shown below.

Cell Contents
A1 Gerard Kelleher
B1 =MID(A1,1,FIND(" ",A1,1)-1)
C1 =MID(A1,FIND(" ",A1,1)+1,LEN(A1))

Then move column B to thr right of C, then delete column B. Personally,
I've preferred names in thier own columns, for the purpose of field headings
above each column.

Hope this helps.
Paul
 
R

RagDyer

You do have the option of using "Text To Columns".
This places each name in it's own column (good for 3 part names) so that you
could move them around as you wish and then concatenate if you so desire.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
Top