The TRIM function in Excel will remove the extra spaces in a Text String leaving a single space between words. How to use the TRIM Formula in Excel is explained in this video.
1. TRIM Function - Intro (0:00)
2. Get the Count of words in a cell (0:52)
3. Get the Last word in a cell (2:03)

Top 25 Microsoft Word Tips and Tricks - https://youtu.be/l25Evu4ohKg
7 Most Important Tools in Excel - https://youtu.be/Pc88LGWNO70
Download my free eBook on Excel Macros - http://eepurl.com/gpT0RD
Check these Books on Excel - https://xlncad.com/excel-resources/
Read my articles on Excel - https://xlncad.com/

If you’ve found my videos helpful or enjoyable, consider supporting me with a coffee!
buymeacoffee.com/ajayanand

Subscribe to @XLnCADMalayalam for Excel, Word, PowerPoint, Access, Python and Power BI Tutorials in Malayalam.
https://www.youtube.com/c/XLnCADMalayalam

Disclaimer: If you click on my affiliates links, I am going to receive a tiny commission. The products that I advertise are the ones I believe in.
My Running Kit for Hyderabad Marathon 2025
https://amzn.to/44IILeG
Think Like an Analyst: Books That Helped Me
https://amzn.to/3SNy6bi
Mind-Opening Reads You Can’t Miss
https://amzn.to/43tM2fu


#trimformula #excelformula #removespaces