CA Rishabh Pugalia (ExcelNext)
1: Converting text written in lower case to first-letter capitalized case
2: Converting text written in mixed case to upper case
3: Removing extra unwanted spaces from the middle of the text-phrase and from the extreme ends (start and close)
Alternatively,
4: Converting nos. stored as text to nos. to ensure correct computation
5: Computing the length of characters in a cell. Used to check the accuracy of data.
CA. Rishabh Pugalia’s other popular articles on Excel tricks at CAClubindia.com – Click Here
Click Here for Online Excel Course for Beginners to Advanced Learners
Click Here for Learn Microsoft Outlook
CAclubindia
