First name last initial extraction

**ExcelRose** · 10-03-2016, 12:40 PM

Hi All,

Need some help with extracting the first name and last initial from the name column. Some names have a middle initial which I won't need. Any help would be appreciated. Thanks!

**José Augusto** · 10-03-2016, 01:00 PM

Try in B2 and copy down

Formula:

Please Login or Register  to view this content.

**ExcelRose** · 10-03-2016, 01:43 PM

Thank you sir!

**Tony Valko** · 10-03-2016, 01:50 PM

Originally Posted by José Augusto

Try in B2 and copy down

Formula:

Please Login or Register  to view this content.

That formula won't work if there are 2 word last names:

Edward Van Halen
Martin St Louis
Lynn St James

It may not be possible to achieve 100% accuracy using a formula.

**deciog** · 10-03-2016, 02:06 PM

Senhoires, yes it is possible to use formula for abreveação names

Look example up to 6 spaces between names

I am using Google translator, English is not my native language

I have helped

Link https://www.sendspace.com/file/zuuqay

Decio of Brazil - São Paulo - SP

First name last initial extraction

LinkBack

Thread Tools

Rate This Thread

Display

First name last initial extraction

Re: First name last initial extraction

Re: First name last initial extraction

Re: First name last initial extraction

Re: First name last initial extraction

Thread Information

Users Browsing this Thread

Similar Threads

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

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

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

First initial last name

First Initial Last Name

Last initial

Remove middle initial from "first name middle initial"

Bookmarks

Bookmarks

Posting Permissions