removing a space between words in a cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

JenBasch - 19 Sep 2005 16:25 GMT

I am trying to figure out how to remove a space between two words in on
cell.

ex: dog house ---- doghouse

Once I figure that out I want it to look through a lot of cells and i
they have a space take it out (above) and if not leave it the way i
is.

Thanks for any help available,
Je

Reply to this Message

swatsp0p - 19 Sep 2005 16:56 GMT

assuming you only have one space per cell to eliminate, use this formul
in another cell (say B1):

B1=LEFT(A1,(FIND(" ",A1)-1))&MID(A1,FIND(" ",A1)+1,LEN(A1)-(FIND(
",A1)))

of course, adjust the cell reference to meet your needs.

A1=dog house returns: doghouse in B1

HTH

Bruc

--
swatsp0

Reply to this Message

David Billigmeier - 19 Sep 2005 17:28 GMT

A LOT easier formula is:
=SUBSTITUTE(A1," ","")

Signature

Regards,
Dave
<!--

> I am trying to figure out how to remove a space between two words in one
> cell.
[quoted text clipped - 7 lines]
> Thanks for any help available,
> Jen

Reply to this Message

Gord Dibben - 20 Sep 2005 00:39 GMT

A LOT easier may be Edit>Replace

what: space

with: nothing

Replace all.

Gord Dibben Excel MVP

>A LOT easier formula is:
>=SUBSTITUTE(A1," ","")

Reply to this Message