TRIM Function – Remove Extra Spaces in Excel
The TRIM function in Excel is used to remove extra spaces from a text string, leaving only a single space between words and no leading or trailing spaces.
Example: From the following data we need to remove extra spaces and we can do it using the TRIM() function in Excel.
Step 1: Write the TRIM formula
The trim function will remove the extra spaces from L2 and the result will be visible in cell M2.
” =TRIM(L2) “
Step 2: Copy Formulas with the Fill Handle
Then, drag the fill handle (a small square at the bottom-right corner of the cell) down to copy the formula for the entire range.
Step 3: Preview Result
The final Data should look like the below
Top Excel Data Cleaning Techniques to Know in 2024
In the world of business and data analysis, being a pro at Excel Data Cleaning is a game-changer. Everyone wants top-notch accuracy and quality in data, right? Well, that’s where Excel comes in handy. Cleaning up your data involves kicking out those pesky blank spaces, fixing mistakes, and updating outdated info.
You can do all of this super easily using Excel Power Query. This tutorial is your go-to guide for mastering the basics of cleaning up your data in Excel. We’re keeping it simple, so you’ll be cleaning data within no time. Get ready to make your data clean in no time.
Contact Us