My Spreadsheet Lab
  • Home
  • Templates
  • Excel Tips
  • Video Tutorials
  • Excel Blog
  • Excel Coach
  • Excel Training
  • Contact Kevin

Day: January 26, 2018

You are here: Home2018January26

Day: January 26, 2018

Change Text to Sentence Case

  • January 26th ,2018
  • Kevin Lehrbass
  • Auditing, Gurus
  • String Manipulation
  • 5
  • 0
  • Share
    • Facebook
    • Google+
    • Twitter
    • Pinterest
    • LinkedIn

As Puneet Gogia mentions in his post, we can change text using UPPER, LOWER and PROPER functions but we don’t have a SENTENCE function to capitalize the first letter of each sentence. Puneet solves it with a very interesting formula. How exactly does it work? Let’s audit it! (more…)

Share

Newsletter

Do You Excel?

Kevin_Col-275x300-small-2019.png
“Improving your Excel skills can change your career!. Visit my 'EXCEL TRAINING' section!”

- Kevin Lehrbass

Excel Made Easy

Learn Excel

Free Templates

Video How-To's

© 2014 My Spreadsheet Lab| Entries (RSS)
website design & development by Engine Communications