Sign up for our Excel webinar, times added weekly: https://www.excelcampus.com/blueprint-registration/
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: https://www.excelcampus.com/functions/remove-blank-spaces

00:00 1. Find & Replace
02:53 2. The TRIM Function
04:30 3. Power Query
06:02 4. Macros and VBA
07:51 5. Trimming Other Characters

Link to the Free Excel Training on The Modern Power Tools:
https://excelcampus.com/blueprint-webinar

Related Videos:

VLOOKUP Tutorial for Excel:
https://www.youtube.com/watch?v=d3BYVQ6xIE4

Power Query Overview - Automate Data Tasks in Excel & Power BI: https://www.youtube.com/watch?v=vq9AgAtSvQg

How to Create Macro Buttons in Excel Worksheets:
https://www.youtube.com/watch?v=bsXZKQCcd5g

How to Create a Personal Macro Workbook in Excel and Why You Need It:
https://www.youtube.com/watch?v=rD2-mSbTuL0&t=94s


#MsExcel #ExcelCampus