How to remove additional spaces in Excel (7 simple ways) | Excel Off The Grid
★ Want to automate Excel? Check out our training academy ★
https://exceloffthegrid.com/academy
★ Check out the blog post & download the example file★
https://exceloffthegrid.com/remove-ad...
★ About this video ★
There are many methods of removing additional spaces from your data in Excel. In this video, we go through several different methods for each, showing the differences and why you would use each one.
0:00 Introduction
0:43 Scenario
1:04 Find and Replace - Method 1
2:00 Flash Fill - Method 2
3:08 TRIM function - Method 3
3:56 SUBSTITUTE function - Method 4
4:46 Using Power Query - Method 5
6:37 Using VBA Macros - Method 6
8:10 Using Office Scripts - Method 7
10:04 Conclusion
★ Download 30 most useful Excel VBA Macros ebook for FREE ★
https://exceloffthegrid.com/
★ Where to find Excel Off The Grid ★
Blog: https://exceloffthegrid.com
Twitter: / exceloffthegrid
#MsExcel #PowerQuery