What Formula to use !

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?