How to remove spaces between cells?

How can you remove all of the unused spaces in an excel file?

• I have run into a problem and do not understand the instructions that I have found. I uploaded a .txt file of addresses. There are a total of 44k. The problem is that when the file was converted to a .xls file, a few of the columns contain numerous spaces after the text. I have a feeling that these were tabs done in the .txt file. When I go to center a column, lets say the street address column, all of the text will line up in the "center", but about 10 spaces to the left because of the 10 blank spaces at the end of each street address. How can I automatically remove all of the unused spaces or spaces over 2 spaces long? I've tried to go through the instructions that I found, but am getting no where. Can someone please give me basic instructions? Say I'm 10 years-old and this is my first time with Excel. Thank You

• Answer:

  Next to your list of data (col A) enter in B2 =TRIM(A2) this will get rid of the unwanted spaces. There is also a CLEAN command which will get rid of all the non printing characters as well. Use the data ibn col B in any formula or printouts I used row 2 as the start of the list to allow for column labels in row 1.