How to convert First, Middle, Last name to Last, First Middle Initial with VBA

**lwine** · 07-29-2013, 12:39 PM

Hello,

I have been working on a macro to export data to another system. The other system will only read names as Last name, First name Middle Initial. Currently names are displayed in a cell as John E. Smith. I need to covert this (in the same cell) to display Smith, John E.

I have searched the forums and have not found exactly what I needed. Thanks for any help!

**:) Sixthsense :)** · 07-30-2013, 01:40 AM

Please attach a sample workbook with enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Note: Please don't attach documents containing confidential data like (address, telephone, ID#s, etc.).

**vlady** · 07-30-2013, 02:27 AM

Moderator's Note:

Will be moving thread to vba/programming subforum. thanks.

**lwine** · 07-30-2013, 09:06 AM

Hi,

I have attached two spreadsheets named, Before and After. I have also attached the macro I have been working on if that helps.

To give you a little more information on my project….

In column A, teams are divided up into 3 groups: PS, NB and MKT. I only need this macro to convert the name for MKT, which I highlighted in both spreadsheets. When I import the data from column B (INDIV ID#), it needs to pull the file and attach itself to these records. I have the other teams working except MKT. The external system that I’m importing the data too will only search based on a Last Name, First Name Middle Initial format (if they have a middle initial). Hopefully this makes sense.

Thanks for any help. The end users are really giving me challenges!!

**jaslake** · 07-30-2013, 02:34 PM

Hi lwine

This Code will work on your sample file...it won't cover all the possible anomalies in the real world. But you can modify as required.

Please Login or Register  to view this content.

**lwine** · 07-30-2013, 02:36 PM

Thanks jaslake!

I'll apply it to my project right away and make the necessary modifications.

**jaslake** · 07-30-2013, 03:33 PM

You're welcome...glad I could help.

If this resolves your issue please mark your Thread as SOLVED.

New quick method:
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

Or you can use this way:
How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save

How to convert First, Middle, Last name to Last, First Middle Initial with VBA

LinkBack

Thread Tools

Rate This Thread

Display

How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Re: How to convert First, Middle, Last name to Last, First Middle Initial with VBA

Thread Information

Users Browsing this Thread

Similar Threads

Extracting the Middle Initial/Middle Name

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

Separate Middle Initial From First Name

Remove middle initial from "first name middle initial"

[SOLVED] First name, Middle Initial

Bookmarks

Bookmarks

Posting Permissions