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…)
Do You Excel?
“Improving your Excel skills can change your career!. Visit my 'EXCEL TRAINING' section!”