Share on Facebook

Share on Twitter

Share on LinkedIn

Share on Email

Share More

 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)


 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 to watch CA  Rishabh Pugalia’s free demo video on VLOOKUP(), Thermometer Charts, What IF Analysis buttons, Time-saver tricks.

. Click here to take the Advanced Excel Certification Course by Grant Thornton in India

"Loved reading this piece by CA Rishabh Pugalia (ExcelNext)?
Join CAclubindia's network for Daily Articles, News Updates, Forum Threads, Judgments, Courses for CA/CS/CMA, Professional Courses and MUCH MORE!"


Category Students, Other Articles by - CA Rishabh Pugalia (ExcelNext)