+ Reply to Thread
Results 1 to 8 of 8

Help needed to convert text into all UPPER CASE

Hybrid View

  1. 08-15-2015, 05:56 PM #1
    RaffPost
    RaffPost is offline
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Question Help needed to convert text into all UPPER CASE

    Hello all,

    Thanks in advance for taking the time to help with my issue.

    I have a work sheet with two dates listed

    A1 = 08/17/2015 (Display is listed as custom text - Monday, Aug, 17, 2015)
    A2 = A1 + 6 (Display listed as custom text - Sunday, Aug 23, 2015)

    Further down into the sheet at various other cells I have selected, I have recognized these cells to equal (=) A1 (Display listed as Mon Aug 17). Cells immediately to the right of these cells have a formula to display the next day and date of the week (Display listed as custom text - Tues Aug 18)

    Date - UPPERCASE.jpg

    What do I need to do to have the text display in ALL UPPERCASE?

    Do I need to change the display in A1? ANd if so how do I go about doing so?

    Thanks in advance.
    Reply With QuoteRegister To Reply
  2. 08-15-2015, 06:07 PM #2
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Help needed to convert text into all UPPER CASE

    Usually this will change case =upper(cell address)
    Make contributors happy, click on the "* Add Reputation" as a way to say thank you.
    Sam Capricci
    Reply With QuoteRegister To Reply
  3. 08-15-2015, 06:08 PM #3
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Help needed to convert text into all UPPER CASE

    Quote Originally Posted by Sambo kid View Post
    Usually this will change case =upper(cell address)
    Dont think that will work here, because teh date is actually a numeric value, not text
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    Reply With QuoteRegister To Reply
  4. 08-16-2015, 05:47 AM #4
    Sam Capricci
    Sam Capricci is offline
    Forum Expert Sam Capricci's Avatar
    Join Date
    06-14-2012
    Location
    Palm Harbor, Florida
    MS-Off Ver
    16.95 for Mac MS 365
    Posts
    8,682

    Re: Help needed to convert text into all UPPER CASE

    Yeah, I saw that after posted. I shouldn't try the "hit and run" postings from my iPad when they "look" like an easy fix but aren't.
    But, he did get the help with a more qualified person when you dropped by.
    Reply With QuoteRegister To Reply
  5. 08-16-2015, 10:26 AM #5
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Help needed to convert text into all UPPER CASE

    Quote Originally Posted by Sambo kid View Post
    Yeah, I saw that after posted. I shouldn't try the "hit and run" postings from my iPad when they "look" like an easy fix but aren't.
    haha been there, done that
    Reply With QuoteRegister To Reply
  6. 08-15-2015, 06:08 PM #6
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Help needed to convert text into all UPPER CASE

    Try this. It is based on A1...
    =UPPER(TEXT(A1+6,"dddd, mmm, dd, yyyy"))

    Note that this is now no longer a value or valid date, it is text...and as such, can no longer be used directly in any calcs.
    Reply With QuoteRegister To Reply
  7. 08-15-2015, 06:30 PM #7
    RaffPost
    RaffPost is offline
    Registered User
    Join Date
    08-09-2015
    Location
    Toronto
    MS-Off Ver
    Microsoft Office 2007
    Posts
    23

    Re: Help needed to convert text into all UPPER CASE

    Quote Originally Posted by FDibbins View Post
    Try this. It is based on A1...
    =UPPER(TEXT(A1+6,"dddd, mmm, dd, yyyy"))

    Note that this is now no longer a value or valid date, it is text...and as such, can no longer be used directly in any calcs.
    Brilliant! Thanks very much!
    Reply With QuoteRegister To Reply
  8. 08-15-2015, 06:37 PM #8
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,048

    Re: Help needed to convert text into all UPPER CASE

    Happy to help
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VB Code to convert text into Upper-Lower Case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-19-2015, 01:00 AM
  2. Convert text to upper case
    By cooper72 in forum Excel General
    Replies: 3
    Last Post: 07-18-2014, 08:59 AM
  3. [SOLVED] Help needed with a formula to convert upper-case words only to lower-case
    By holmwood in forum Excel General
    Replies: 7
    Last Post: 04-18-2014, 04:11 PM
  4. [SOLVED] Convert 1st letter of word to Upper Case and rest to lower case
    By rizmomin in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 05-23-2013, 11:44 AM
  5. [SOLVED] Convert Text to Upper Case?
    By NickPDC in forum Excel General
    Replies: 4
    Last Post: 02-02-2011, 12:11 PM
  6. How to convert a column of text to upper and lower case?
    By jewell b in forum Excel General
    Replies: 1
    Last Post: 08-06-2006, 04:10 AM
  7. How do I convert all upper case excel sheet into upper and lower .
    By DebDay in forum Excel General
    Replies: 1
    Last Post: 03-09-2005, 05:06 PM

Tags for this Thread

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