Removing spaces from text in Excel
I’ve been meaning to come up with a way to create an Excel library for tasks I do very often; I suppose this will be a good place to start it and update it.
The TRIM function removes spaces from the right and left sides of whatever text you’re processing, like so:
Formula:
=TRIM(A1)
” Hello ” will process to: “Hello”
However, if you want to remove spaces from within a text cell, leaving all other characters / numbers / etc., you need to use the SUBSTITUTE function for simple cases.
Formula
=SUBSTITUTE(A1," ","")
” Hello Thar ” will process to “HelloThar”
First in what will probably be a lot of posts about Excel stuff. I use it WAY too often for text processing.