+ Reply to Thread
Results 1 to 3 of 3

Capital Alphabet

  1. #1
    Registered User
    Join Date
    01-11-2014
    Location
    Malaysia
    MS-Off Ver
    Excel 2013
    Posts
    37

    Capital Alphabet

    Hi all,

    How to make an selected column or row to capital words. with or without caplock?

  2. #2
    Valued Forum Contributor
    Join Date
    11-15-2007
    Location
    England
    MS-Off Ver
    Office Pro 2003 / 2010
    Posts
    423

    Re: Capital Alphabet

    Quick way is to insert a column and type =UPPER(A1). Copy down the column copy and paste as values and paste over original text. PROPER(A1) Will give you a capitalised first letter of each word.

  3. #3
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2403 Win 11 Home 64 Bit
    Posts
    23,811

    Re: Capital Alphabet

    Try this code:

    Please Login or Register  to view this content.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Capital letters
    By NadineJordy in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 06-10-2013, 06:20 AM
  2. Alphabet AA to ZZ?
    By fasterthanyours in forum Excel General
    Replies: 2
    Last Post: 11-23-2009, 02:15 PM
  3. Capital
    By Roger in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 05-12-2006, 01:50 PM
  4. Replies: 2
    Last Post: 07-26-2005, 03:05 AM

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