Remove spaces from a cell in Excel

I use Excel a lot to manipulate raw text data.  One thing I need to do often is remove spaces from a cell, here are 2 approaches you can use:

Permanently remove spaces from data:

Highlight the row(s) or column(s) that you want to work with then use the search and replace function (Ctrl + F followed Alt + P) to find and replace a space with nothing.  That is make sure the search box contains a single space and the replace box is empty. 






Remove spaces dynamicly

Using this formula will remove spaces dynamicly which makes it much better for workign with live changing data, it can also be used as one step in a series of transformations:

=SUBSTITUTE(A25," ","")

where A25 is the cell that contains the ‘source’ data.

Posted on August 5, 2012 at 19:21 by simon · Permalink
In: Excel

One Response

Subscribe to comments via RSS

  1. Written by Johnc385
    on 17 May 2014 at 6:38
    Reply · Permalink

    Hey very nice blog!! Man .. Beautiful .. Amazing .. I’ll bookmark your website and take the feeds alsoI am happy to find a lot of useful info here in the post, we need work out more techniques in this regard, thanks for sharing. . . . . .

Subscribe to comments via RSS

Leave a Reply