Converting text based on criteria

[keith740]

good afternoon forum!

i have a list of employees (hundreds) split up into 3 teams in column A... they have tags at the end of their name, the tags are -AA,-AB, and - V

i need column B to display a converted version of the cell to left.

i need the names with -AA, and -AB in column A to show in column B as: move the tag to the front of name but only with one A,space,-,space,first name,last initial
example: John Wood-AB would show as A - John W


The names with V(column A) to show in column B as: move the tag to the front of name,space,-,space,first name,last initial,
example:John Wood- V would show as V - John W

Attached is an example and what i am looking for

I know this is an awkward request, is this possible?

Ty in advance