Liam Delahunty: Home Tips Web Contact
Recommended laptop
under £500
.

Think I deserve a present? See my Amazon Wish List

Microsoft Excel - Convert String to Sentance Case

Problem: Excel has built in functions for PROPER (title) case, UPPER and LOWER but lacks sentance case - the first character is in upper case and the rest are lower.

Solution: Use Word! Copy the cells from Excel. In Word Press Alt+E then S for Paste Special.

Select Unformated Text

Now select all the test and press Alt+O (format), E (case), S (Sentance Case).

Copy all the text again.

Back in Excel, Paste Special, Text and you should find the cells now contain the correct formating.

Related Links

Share this!  



Excel Password Protect | Excel Sentance Case | Excite Plays Hide The Free Submit Link


 

  Tips | Home | Search | Contact

Link here: