Swap 'last name and initials'

[Mel Smith]

I've tried to search on this but couldn't find anything.

I have a long list of employees entered in the form of Last name<space>Initial(s)

Is there a formula that I could use to swap these entries to become Initial(s)<space>Last name?

Thanks for your suggestions.

Mel

 

[Mel Smith]

A lot of searching and I found this, which does just what I want.

=MID(A2&" "&A2,FIND(" ",A2)+1,LEN(A2))

Mel

 

[alansidman]

You could also use Flash Fill since you are running O365

 

[Mel Smith]

Thanks, Alan.

I wasn't aware of flash Fill - many thanks!

Mel

 

[alansidman]

You are welcome.