Reversing name format

  • Thread starter Thread starter Gerry
  • Start date Start date
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
 
=MID(A1,FIND(" ",A1)+1,LEN(A1))&" "&LEFT(A1,FIND(" ",A1)-1)

Only works with two names though.
 
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
 
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!
==============================================
 
Back
Top