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!