Channel: Excel Campus - Jon

Category: Education

Tags: excelremove spaces excelexcel remove unwanted spacesremove trailing spacesreplace spaces excelremove extra spaces excelexcel remove spacesexcel campusspaces excelremove leading spaces in excelremove non-breaking spaceexcel remove nonbreaking space

Description: In this video, you can learn 5 different techniques to find and remove spaces in Excel. Spaces can cause formula errors and frustration with data preparation and analysis. The five ways we explore to remove them are Find & Replace, the TRIM function, Power Query, Macros/VBA, and LEFT & LENGTH functions. If you’d like to read the accompanying blog post on my website, you can access it here: excelcampus.com/functions/remove-blank-spaces 0:00 1. Find & Replace 2:53 2. The TRIM Function 4:30 3. Power Query 6:02 4. Macros and VBA 7:51 5. Trimming Other Characters Link to the Free Excel Training on The Modern Power Tools: excelcampus.com/blueprint-webinar Related Videos: VLOOKUP Tutorial for Excel: youtube.com/watch?v=d3BYVQ6xIE4 Power Query Overview - Automate Data Tasks in Excel & Power BI: youtube.com/watch?v=vq9AgAtSvQg How to Create Macro Buttons in Excel Worksheets: youtube.com/watch?v=bsXZKQCcd5g How to Create a Personal Macro Workbook in Excel and Why You Need It: youtube.com/watch?v=rD2-mSbTuL0&t=94s #MsExcel #ExcelCampus