Reordering Last Name, First Name, Middle Initial to First Name, Middle Initial, Last Name

**James Ray** · 09-14-2016, 03:28 AM

Good day,

i have here my sample formula about reordering Last Name, First Name, Middle Initial to First Name, Middle Initial, Last Name. what i am confusing is how about with name extension like Jr., II, III, etc.

what excel formula should i use?
Screenshot_1.jpg

**Special-K** · 09-14-2016, 04:55 AM

The data has clearly been entered incorrectly. It should be

Doe III, Jane Q.

I dont think you'll ever be able to sort this type of data out without doing it manually.
Or you may be able to check for parts like I II II Jr Sr but you'll need to think about what ALL of them might be.

Reordering Last Name, First Name, Middle Initial to First Name, Middle Initial, Last Name

LinkBack

Thread Tools

Rate This Thread

Display

Reordering Last Name, First Name, Middle Initial to First Name, Middle Initial, Last Name

Re: Reordering Last Name, First Name, Middle Initial to First Name, Middle Initial, Last N

Thread Information

Users Browsing this Thread

Similar Threads

Formula to extract First initial, Middle initial and Last name from cell

[SOLVED] How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Extracting the Middle Initial/Middle Name

Changing (First Name Middle Initial Last Name) to (Last Name, First Name Middle Initial)

Remove middle initial from "first name middle initial"

[SOLVED] First name, Middle Initial

Stripping Middle Initial from a Name

Bookmarks

Bookmarks

Posting Permissions