Formatting names, first initial and last name, can't figure out how to format

**mmccra2858** · 04-17-2021, 12:07 PM

I have a sample list of names attached.
I was able to bring in the first initial of the first name and the last name.
I need to add a period to the end of the first initial and a space between the period and last name.

Thanks for the help.

**TMS** · 04-17-2021, 12:28 PM

Maybe:

Formula:

Please Login or Register  to view this content.

Formatting names, first initial and last name, can't figure out how to format

LinkBack

Thread Tools

Rate This Thread

Display

Formatting names, first initial and last name, can't figure out how to format

Re: Formatting names, first initial and last name, can't figure out how to format

Thread Information

Users Browsing this Thread

Similar Threads

two names in same cell, need to get first initial + last name please.

[SOLVED] Split Names (Some with Middle Initial)

Display the initial from a cluster of names

[SOLVED] Create a Drop down that will list all names starting with initial letter of names.

[SOLVED] have list of names and want to switch names around by putting the first initial last

[SOLVED] Excel 2007 : Help - Need data to copy from a larger table when i add a certain initial figure

[SOLVED] Convert names into initial caps

Bookmarks

Bookmarks

Posting Permissions