Results 1 to 3 of 3

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

Threaded View

jordan1214 Formula to Convert First/Last... 02-28-2013, 02:02 AM
jraj1106 Re: Formula to Convert... 02-28-2013, 02:07 AM
Alf Re: Formula to Convert... 02-28-2013, 02:17 AM
  1. 02-28-2013, 02:17 AM #3
    Alf is offline
    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 
    =RIGHT(A1,LEN(A1)-FIND(" ",A1))&" "&LEFT(A1,1)&"."
    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 With QuoteRegister To Reply
« Previous Thread | Next 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1