1. Computer problem? Tech Support Guy is completely free -- paid for by advertisers and donations. Click here to join today! If you're new to Tech Support Guy, we highly recommend that you visit our Guide for New Members.

Converting excel table to all CAPS?

Discussion in 'Business Applications' started by iqwertyi, Apr 13, 2004.

Thread Status:
Not open for further replies.
Advertisement
  1. iqwertyi

    iqwertyi Thread Starter

    Joined:
    Feb 4, 2004
    Messages:
    13
    is there a way to convert an excel table to be all caps?

    I really do not feel like retyping all these tables again.

    Thanks in advance.
     
  2. maxflia10

    maxflia10

    Joined:
    Feb 24, 2003
    Messages:
    331
    You could try ASAP Utilities......(Hi Andy..... :D )

    www.asap-utilities.com

    Look under Text...
     
  3. littlemar

    littlemar

    Joined:
    Jul 12, 2001
    Messages:
    9,082
    UPPER - Converts text to uppercase.

    Syntax
    UPPER(text)

    Text is the text you want converted to uppercase. Text can be a reference or text string.

    Example

    The example may be easier to understand if you copy it to a blank worksheet.

    1. Create a blank workbook or worksheet.
    2. Select the area you want changed. Do not select the row or column headers.
    3. Press CTRL+C.
    4. In the worksheet, select cell A1, and press CTRL+V.
    5. To switch between viewing the results and viewing the formulas that return the results, press CTRL+` (grave accent), or on the Tools menu, point to Formula Auditing, and then click Formula Auditing Mode.
    A
    1 Data
    2 total
    3 yield

    Formula Description (Result)
    =UPPER(A2) Upper case of first string (TOTAL)
    =UPPER(A3) Upper case of second string (YIELD)
     
  4. XL Guru

    XL Guru

    Joined:
    Aug 30, 2003
    Messages:
    2,702
    (Hi maxflia10)

    Just another option, a very straightforward one if you have MS Word.

    Copy the table and paste it into a blank Word doc.

    Select the table & use Word's own Format -- Change Case.

    Copy the table again and Paste Special in XL as plain text, over the original table.

    Rgds,
    Andy
     
  5. iqwertyi

    iqwertyi Thread Starter

    Joined:
    Feb 4, 2004
    Messages:
    13
    Thanks everyone for responding.

    Went with the very basic route (XL Guru's) suggestion.

    I also downloaded asap-utilities but have not installed yet since it's the works computer and they got some policies on apps installed.

    Thanks again everyone.
     
  6. Sponsor

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 733,556 other people just like you!

Loading...
Thread Status:
Not open for further replies.

Short URL to this thread: https://techguy.org/220015