It's actually two steps. First, use a TRIM function to strip out the
leading/trailing spaces:

=TRIM(A2)

....and copy down as far as needed.

Next, copy the entire set of cells you just created and select Copy, select
the first cell in the original data, then Edit Paste Special Values to
paste the new data back over the top of the old. You can now delete the
helper cells.

Repeat with any other columns.

--
"Actually, I AM a rocket scientist." -- JB


"SMS" wrote:

I transposed data from multiple columns into rows. Most of the cells contain
text that has a blank space before the word. I want to remove this blank
space at once (without having to go into each cell and backspace)