How to Change the Name Order From First to Last in Excel

Written by ken burnside Google
  • Share
  • Tweet
  • Share
  • Pin
  • Email
How to Change the Name Order From First to Last in Excel
Excel can convert the order of first and last names using LEN. (number background image by kuhar from Fotolia.com)

Excel is frequently used as a lightweight database application for tracking contact lists and similar information. When data, such as names, is imported from other applications, it may not be in the format desired. For example, a name might be put in a list as Adam Smith, rather than Smith, Adam. Converting names from one format to another can be done easily through the use of the LEN command in Excel.

Skill level:
Moderately Easy

Other People Are Reading

Instructions

  1. 1

    Open your list of names in Excel. The list of names should be in column A.

  2. 2

    Enter the following formula in column B1:

    =RIGHT(A1,LEN(A1)-FIND(" ",A1))

    Note that there is a space between the quotation marks in the find function.

  3. 3

    Enter the following formula in column C1:

    =LEFT(A1,LEN(A1)-LEN(B1)-1)

  4. 4

    Enter the following formula in column D1:

    =CONCATENATE(B1,", ",C1)

  5. 5

    Copy the contents of cells B1, C1 and D1 down for as many rows as you have names. For example, if your name list goes to row 200, make sure you copy the contents of cells B1, C1 and D1 down through B200, C200 and D200.

Don't Miss

Filter:
  • All types
  • Articles
  • Slideshows
  • Videos
Sort:
  • Most relevant
  • Most popular
  • Most recent

No articles available

No slideshows available

No videos available

By using the eHow.co.uk site, you consent to the use of cookies. For more information, please see our Cookie policy.