I've been able to do this for any specific word e.g.

Manager, Department
Manager, Regional

with a basic function but it requires me to re-do for each word.

Is there anyway to set up a function that simply swaps anything before the ,
with anything after (removing the , in the process)?

Thanks in advance for any help!