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 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

CAclubindia's WhatsApp Groups Link

 

12 Likes   1129 Shares   577335 Views

Comments


Related Articles


Loading



Popular Articles




Certificate in Quantitative Finance IIM Calcutta Applied Finance(Batch 17) GST Course
Follow us


CCI Articles

submit article