Results 1 to 2 of 2

Thread: Excel formula for converting First letter to CAPS

  1. #1

    Excel formula for converting First letter to CAPS



    Register for a FREE account, and/
    or Log in to avoid these ads!

    Hi!

    I have a Excel column 'B' with MIDDLE NAMES, either it will be a word or a letter ( all i need is the 1st letter to be converted to CAPS, regardless its 1 word or letter)

    E.g.:

    ivana Ivana
    m M
    Geetha Geetha

    Hope you got me!

  2. #2
    Super Moderator NBVC's Avatar
    Join Date
    May 2011
    Location
    Mississauga, Canada
    Posts
    1,489
    Articles
    0
    Excel Version
    Excel 2016
    Try PROPER()

    e.g

    =PROPER(A2)


Tags for this Thread

Posting Permissions

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