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.
on 17 May 2014 at 6:38
· 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. . . . . .