removing a space between words in a cell

J

JenBasch

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
 
S

swatsp0p

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
 
G

Gord Dibben

A LOT easier may be Edit>Replace

what: space

with: nothing

Replace all.


Gord Dibben Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trim cells with space in betwen numbers in cell 2
Combining text from several cells into 1 cell 4
Remove non-space spaces? 3
Removing spaces between words in MS Word 6
space between words 4
Split words in a cell 4
TRIM IF CELL CONTAINS ONE WORD, ABBREVIATE IF IT CONTAINS MULTIPLE WORDS 1
eliminate space at beginning of line 1

Top