1. Computing
Ted French

Remove Extra Spaces from Data in Excel

By December 28, 2013

Follow me on:

Remove Extra Spaces From Between Data
Remove Extra Spaces From Between Data
Ted French

Sometimes, when you import data into a worksheet, extra spaces show up between the words or numbers.

Extra spaces between words can make it difficult to read the information.

Extra spaces in numbers can cause errors when you try to use them with some of Excel's functions.

A quick and easy way to fix these problems is to use the TRIM function.

The TRIM function works by extracting the good data from the original and copying it to a new location in the worksheet.

To find out the details, read this short tutorial on how to Remove Extra Spaces From Data in Excel.

Related Tutorials

Comments
No comments yet. Leave a Comment
Leave a Comment

Line and paragraph breaks are automatic. Some HTML allowed: <a href="" title="">, <b>, <i>, <strike>

©2014 About.com. All rights reserved.