reorganize within one cell

[Rnash]

I have a need to move the suffix (ex: Jr) to the end of names within a list samples of names:

WALTER J SR HARRISON
CHARLES C JR HART
JOHN E JR HART
CLARENCE LEO JR HARTWICH

The amount of first/middle/initials that comes before varies.

I'd appreciate the help.

[scottwhittaker2333]

Im not sure if it will work but you my be able to do a find and replace
something like

Find "*"&" "&"*"&" "&"jr"&" "&"*"
Replace "*"&" "&"*"&" "&"*"&"jr"

[Rnash]

No luck with that, but thanks for trying.

[mrice]

Assuming that your original list is in column A, try pasting the following into B1 and dragging down.

Please Login or Register  to view this content.

[teylyn]

Is the last name always only one name? If not, this is going to be difficult.

[Rnash]

Works perfectly - thanks sooooo much!

[pike]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

[Marcol]

A bit late but another way might be

Please Login or Register  to view this content.

Assuming all data is upper case.

[martindwilson]

and a bit shorter still
=IF(ISERROR(SEARCH(" ?r ",A1)),A1,REPLACE(A1,SEARCH(" ?r ",A1),3,"")&" "&MID(A1,SEARCH(" ?r ",A1)+1,2))