Hi,

What formula could i use to re-arrange a name format.

Current name format: Lastname, Firstname

Expected Outcome: Firstname.Lastname

Wanted to lookup an employee to what supervisor he is under.
Its tiresome to edit the name of the supervisor when you have over 200+ agents and more than 30 supervisor.