This is a guest blog by Elene Marsden from CorazonIT 

There’s a simple shortcut in Microsoft Word to convert Upper Case text to Title Case (or camel case as someone once described it to me!) highlight the text and select Shift F3.

There’s no shortcut in Excel but if you use the formula shown in this video you can achieve the same results.

If you like consistency and tidy data, you’ll love this How To video

If you want to get the complete Excel training course visit

http://www.corazonit.com/excelfundamentals.html

www.betteractnow.com

  • October 10, 2012
Click Here to Leave a Comment Below 1 comments
Sarah-Jane Quick

Very true, but you can copy the column in Excel, go to Word and paste it in — Shift F3 to go from caps to U/LC and then paste it back into Excel. Bit of a fiddle but I have to do it all the time, so you get faster at it!!

Reply

Leave a Reply: