+ Reply to Thread
Results 1 to 9 of 9

Excel 2007 : Suffix formula needed for the Jr, Sr, III in Excel 2007

Hybrid View

  1. #1
    Forum Expert teylyn's Avatar
    Join Date
    10-28-2008
    Location
    New Zealand
    MS-Off Ver
    Excel 365 Insider Fast
    Posts
    11,375

    Re: Suffix formula needed for the Jr, Sr, III in Excel 2007

    You can't. There are just too many possible variations of names to come up with a rule to decide if the last word in a text string should be all caps or not.

    It's easy to find a way to capitalise the last word in every instance, but then you'll end up with situations like

    Kent C & Cathy Honda III
    John & Mary BLOGGS
    James C & Mary June HIGGINS
    Barbara Taylor BRADFORD
    Kim S & Su Wong II

    etc.

    You may want to use your formula as is and then send the spreadsheets through some Replace commands, like

    replace Iii with III
    replace Ii with II

  2. #2
    Forum Expert Paul's Avatar
    Join Date
    02-05-2007
    Location
    Wisconsin
    MS-Off Ver
    2016/365
    Posts
    6,887

    Re: Suffix formula needed for the Jr, Sr, III in Excel 2007

    Recently cross-posted at MrExcel.

    http://www.mrexcel.com/forum/showthread.php?t=415393

+ 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