FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week
Excel In Seconds Tips and Tricks from The Excel Addict - Microsoft Excel 2003, 2007, 2010, 2013, 2016, 365



September 13, 2016

Hi fellow Excel Addict,

I hope you will find today's 'Excel in Seconds' tip, 'A Case for Fixing Typing Mistakes' helpful for those, hopefully rare, times when you need it.

If you missed last Thursday's 'Excel in Minutes' tip, 'Determine if a Date Falls Within a Certain Number of Days of Another Date', you can read it here now.

Please feel free to share my newsletter with your friends — chances are they will thank you for it.

Wishing you a great week end keep on Excelling,
Francis Hayes (The Excel Addict)
Email: 
fhayes[AT]TheExcelAddict.com



TheExcelAddict.com Quote of the Day

"Tell me, what is it you plan to do with your one wild and precious life?"

-- Mary Oliver --




If you missed my last newsletter, you can click here to view it online.



Excel in Seconds with TheExcelAddict.com

A Case for Fixing Typing Mistakes

If you're a 4-finger typist like me who can't look at the screen and type at the same time, no doubt you have occasionally typed a full sentence (or more) of uppercase text in Excel before you realized it.

How To Convert Upper Case Sentence in Microsoft Excel 2007 2010 2013 2016 365
As well, this will be useful if you've imported data that came in as all upper case.

Rather than retype the whole sentence, especially if it's really long, or worse yet, if you've typed an entire paragraph, here is a quick way to fix your mistake.

Although I've broken this out into 7 detailed steps below, really it only takes a couple of seconds to do.

1) In a blank cell type nearby, type =LOWER(

2) Next, select the cell with the offending text and the cell address will be inserted into the LOWER function e.g. =LOWER(A2;

3) Type a closing ) to finish the function, then press ENTER;

4) Now, point to the edge of the cell containing the LOWER function and the mouse pointer will change to a 4-headed arrow;

5) 
Click and drag with your right mouse button and drop it onto the original cell;

6) From the menu that pops up choose 'Copy Here as Values Only'. The upper case text will be replaced by the lowercase text;

Convert Upper Case Text To Lower in Microsoft Excel 2007 2010 2013 2016 365

7) Finally you can delete the temporary LOWER function from the other cell.

Oh yes. Also check your sentence for proper names, etc... that may need to be re-capitalized.

Yeah, I really should have learned to type properly.

Other CASE related functions:

=UPPER(text) converts text to all upper case.
=PROPER(text) converts text to lower case and then capitalizes the first letter of each word.

Word? Outlook? Why not Excel too?
I want to thank Excel Addict reader Lucy Moore, who informed me that in MS Word and Outlook you can use the SHIFT+F3 keyboard shortcut to toggle selected text between UPPER, LOWER and SENTENCE case.



FREE Excel Tips Newsletter from TheExcelAddict.com
Subscribe here to get more tips like this every week

Thanks for supporting this newsletter and website

Earnings Disclosure: Some of the resources I recommend on my website and in my newsletter pay me a small referral commission if you purchase from them through links on my website or using my referral code. This helps offset the costs of my website. I've worked long and hard to build up my reputation online over the past 10 years as someone who provides exceptional value to my readers. So I'm not willing to risk that for a few dollars. As you know, I don’t just recommend anything. It has to be of outstanding quality and value. If you are ever not completely satisfied with anything I recommend, please let me know and I will get your money back for you...GUARANTEED. You can't lose.
 'Spreadsheets Tips From An Excel Addict' and 'Excel in Seconds' are publications of TheExcelAddict.com.
Copyright Francis Hayes All Rights Reserved.
8 Lexington Place, Conception Bay South, Newfoundland, Canada, A1X 6A2 Phone: 709-834-4630