Removing spaces from middle of cell

  • Thread starter Thread starter TJAC
  • Start date Start date
T

TJAC

In my spreadsheet there is a column that contains number, 3 on the left,
space, 3 on the right. I want to remove that space. Rather than doing this
in three steps, taking left, then taking right, then joining those together,
is there an easier way to accomplish the same thing.

It currently looks like this 216 123
I want it to be this 216123

I'm sure there is an easier way, but I only know how in three steps.

Thanks!
 
Hi,

One way is to use the formula below in a helper column and then copy the
helper column and paste special|Values back over the original data. you can
then delete the helper column

=SUBSTITUTE(A1," ","")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
 
In my spreadsheet there is a column that contains number, 3 on the left,
space, 3 on the right. I want to remove that space. Rather than doing this
in three steps, taking left, then taking right, then joining those together,
is there an easier way to accomplish the same thing.

It currently looks like this 216 123
I want it to be this 216123

I'm sure there is an easier way, but I only know how in three steps.

Thanks!
Click to expand...

Another way would be to use FIND/REPLACE
Find what: <space>
Replace with: "just leave this blank"

--ron
 
Much easier and faster than mine. Thank you!

Mike H said:
Hi,

One way is to use the formula below in a helper column and then copy the
helper column and paste special|Values back over the original data. you can
then delete the helper column

=SUBSTITUTE(A1," ","")
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.
Click to expand...
 
Back
Top