Sponsors:

• File Encryption
• FREE Antivirus Downloads
• Data Recovery
• Printer
• Network Lawful Intercept
• Computer Storage Cabinets
• Security Seals

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

• How to find a question mark in Microsoft Excel
• Microsoft Excel keyboard shortcuts
• Microsoft Excel large number error
• Microsoft Excel how to password protect a document

Share this!  

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

  Tips | Home | Search | Contact