Look Who it Was Random video

Excel - How to Remove Leading Spaces and Keep Interior Spaces Intact - Episode 466

312 views · Published 18 May 2009 · 2:54 · Indexed 20 September 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  How to Remove Leading Spaces and Keep Interior Spaces Intact.

Welcome back to the MrExcel Podcast! I'm Bill Jelen and I'm currently on my way home from the Microsoft MVP's Summit in Seattle. It was an amazing experience to be surrounded by 32 Excel experts and to have the opportunity to catch up with the folks at Microsoft who are already working on Office 14, set to be released in 2009 or 2010. It's clear that Excel is far from finished and there are many exciting updates and improvements in the works.

In this episode, we'll be addressing a question from George about dealing with leading and interior spaces in Excel. George had used the "edit replace" function to get rid of the leading spaces in his data, but it also removed the interior spaces which he wanted to keep. My solution to this is to insert a new column and use the "trim" function to remove the leading spaces while leaving the interior spaces intact. This function is also useful for reducing multiple interior spaces down to one.

But that's not all! While I was at the MVP Summit, I asked various experts to share their favorite Excel tips in a two-minute segment. So for the next ten episodes, we'll have guest podcasters sharing their top tips with you. These guests include well-known bloggers like Dick Kusleika from Daily Dose of Excel and authors like John Walkenbach from the Bottomless Pit. Make sure to tune in over the next few weeks to learn from these Excel gurus.

Thank you for stopping by and joining us for another episode of the MrExcel Podcast. Don't forget to subscribe and hit the notification bell so you don't miss any of our upcoming episodes. See you next time!

Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/

You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/

Table of Contents:
(00:00) Introduction to the MrExcel Podcast
(00:20) Bill Jelen's trip to the Microsoft MVP's Summit
(00:30) Upcoming changes in Office 14
(01:04) Question from George about removing leading spaces in Excel
(01:23) Solution using the TRIM function
(02:07) Special guests sharing their favorite Excel tips
(02:35) Clicking Like really helps the algorithm

#excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial 

This video answers these common search terms:
Bottomless book
Copy and Paste Special values
Daily Dose Of Excel
Edit replace
Excel experts
Excel leading spaces
Microsoft MVP's Summit
Office 14
Trim function in Excel
Two minute tip in Excel

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152420/



Episode 466 shows how to get rid of leading spaces while leaving the interior spaces intact. Plus news on Microsoft MVP Summit from Seattle and preview of Excel guest appearances on the MrExcel podcasts.

This blog is the video podcast companion to the book, Learn Excel from MrExcel. Download a new two minute video every workday to learn one of the 277 tips from the book!

More from this channel