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

 

What did you think of this article?




Trackbacks
  • No trackbacks exist for this post.
Comments
  • No comments exist for this post.
Leave a comment

Submitted comments are subject to moderation before being displayed.

 Name (required)

 Email (will not be published) (required)

 Website

Your comment is 0 characters limited to 3000 characters.