Reverse $String1, String2 to $String2 $String1?

[msnyc07]

I've done separate functions for specific text e.g.
Manager, X = X Manager
Supervisor, X = X Supervisor

but would love if i could just make a generic
Y, X = X Y

is that doable?

Thanks in advance!

 

[T. Valko]

Try this...

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