Reversing name format

[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

 

[Ken Wright]

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

Only works with two names though.

 

[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

 

[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!
==============================================