Reverse $String1, String2 to $String2 $String1?
 

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!

Reverse $String1, String2 to $String2 $String1?
 

Try this...

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

--
Biff
Microsoft Excel MVP


"msnyc07" wrote in message
...
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!