What Formula to use !

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.

Assuming your data is in A2.

Something like:

=RIGHT(A2,LEN(A2)-SEARCH(", ",A2,1))&"."&LEFT(A2,SEARCH(",",A2,1)-1)

Cheers

Originally Posted by southward

Assuming your data is in A2.

Something like:

=RIGHT(A2,LEN(A2)-SEARCH(", ",A2,1))&"."&LEFT(A2,SEARCH(",",A2,1)-1)

Cheers

Thank you for the Help Southward.

So now we want to reverse the process how should we proceed sir?

Sorry Sir let me elaborate.

After Converting the name format from Lastname, FirstName to Firstname.Lastname (I have now verified which employee is aligned to a supervisor using lookup in this case)
now im ready to upload the data to our system but it only accepts the original name format which is.

Lastname, Firstname

How to do it then?
Sorry new in Excel

Here to go:

=RIGHT(A2,LEN(A2)-SEARCH(".",A2,1))&", "&LEFT(A2,SEARCH(".",A2,1)-1)

Cheers