Share via

Office for Mac - How do I change case in excel

Anonymous
2011-12-28T03:29:48+00:00

I know the answer is probably simple but how do I change from lower case to upper case in Excel (Office for Mac)

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

  1. Anonymous
    2017-11-30T19:50:23+00:00

    Hey Jim,

    Sorry for venting my frustration at you and yes, I searched for Excel and didn't notice the title - my mistake.

    It seems silly to experts but why wouldn't you want one button access to basic data cleaning? There are plenty of other word processor-like tools in Excel.

    In the end, switching to Apple Numbers and using their text/case tools to clean the data solved things.

    Thanks for taking the time to read and post, much appreciated.

    Cheers

    7 people found this answer helpful.
    0 comments

Answer accepted by question author

  1. Bob Jones AKA CyberTaz MVP 435K Reputation points
    2011-12-28T12:25:30+00:00

    Without any details all I can suggest is that you investigate the UPPER() function in Excel Help:

    UPPER function

    You can then copy the results & use Edit> Paste Special - Values to replace the content in the original cells with the formula results. Once the replacement is made you can delete the content of the cells used for the function.

    Regards,

    Bob J.

    4 people found this answer helpful.
    0 comments

16 additional answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2016-06-04T14:34:01+00:00

    This is pretty obvious but it works and is quick. If your text data is in a block, select and copy it, paste into a blank Word document, select it, change case, copy, paste back into the spreadsheet. If you're handy with VBA, you could probably do this with a macro, or you can create a macro with a macro utility such as Keyboard Maestro to do the job repeatedly in the future.

    3 people found this answer helpful.
    0 comments
  2. Anonymous
    2016-02-10T19:03:16+00:00

    The windows version of Excel has the ability to change case in a cell without using a formula. Why doesn't the OS X Version?

    3 people found this answer helpful.
    0 comments
  3. Anonymous
    2011-12-29T12:53:15+00:00

    There's no simple answer (Excel is a spreadsheet, not a word-processing application, so it doesn't have a lot of text-manipulation functions).

    You might find the add-in "JEMChangeCase" useful:

    http://skydrive.live.com/?id=35EC6344693974C9%21115

    it adds a Change Case menu item to the Format menu, which brings up a userform very similar to Word's Change Case Dialog.

    1 person found this answer helpful.
    0 comments