Reversing the Order of Last and First Names in Your Excel Spreadsheet
The following formula for your excel worksheet changes the order of a name from
Last Name, First Name-Middle
to
First Name, Middle-Last Name.
In order for this to work, every cell entry can only contain one comma:
=RIGHT(A1,LEN(A1)-LEN(LEFT(A1,FIND(",",A1)-1))-2)&""&LEFT(A1,FIND(",",A1)-1)
NOTE: Do not delete column A. Doing so will result in an #REF error in column B, as the formula in B references Column A. If you must delete Column A, first copy the data in column B and use Edit, Paste Special, Values to copy the data to an empty column. Once the values are pasted, you can delete both Columns A and B.
Except from the NETWORK RISER E-Newsletter published by Rogers Executive Administrative Services found at http://www.easmyworkload.com/Network%20Riser%20Archives.html




Comments