+ Reply to Thread
Results 1 to 3 of 3

Formula to Convert First/Last Name to 1st Letter of 1st Name + Full Last Name

  1. #1
    Registered User
    Join Date
    02-17-2013
    Location
    FL
    MS-Off Ver
    Excel 2003
    Posts
    81

    Formula to Convert First/Last Name to 1st Letter of 1st Name + Full Last Name

    Hello, I was able to get help with an issue similar to this last time so I figured I would post here. This is an example of what I want to do:

    A group of cells with a full name (example, Tom Henry - Cell A1) I want to convert that to T. Henry in Cell B1.

    I want to use the formula for this because I will want to change a large group of cells from the full name to first initial of first name + full last name.

    Thanks!

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2012
    Location
    Mauritius
    MS-Off Ver
    Excel 2007
    Posts
    1,055

    Re: Formula to Convert First/Last Name to 1st Letter of 1st Name + Full Last Name

    Hi.

    Check this out:

    Please Login or Register  to view this content.
    Click *, if my suggestion helps you. Have a good day!!

  3. #3
    Forum Expert Alf's Avatar
    Join Date
    03-13-2004
    Location
    Gothenburg/Mullsjoe, Sweden
    MS-Off Ver
    Excel 2019 and not sure I like it
    Posts
    4,784

    Re: Formula to Convert First/Last Name to 1st Letter of 1st Name + Full Last Name

    You could try
    Please Login or Register  to view this content.
    Gives the wrong formate! Did not read OP's request properly my bad.

    Alf
    Last edited by Alf; 02-28-2013 at 02:23 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1