Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]() I am trying to figure out how to remove a space between two words in one cell. ex: dog house ---- doghouse Once I figure that out I want it to look through a lot of cells and if they have a space take it out (above) and if not leave it the way it is. Thanks for any help available, Jen -- JenBasch ------------------------------------------------------------------------ JenBasch's Profile: http://www.excelforum.com/member.php...o&userid=27369 View this thread: http://www.excelforum.com/showthread...hreadid=468842 |
#2
![]() |
|||
|
|||
![]() assuming you only have one space per cell to eliminate, use this formula 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 Bruce -- swatsp0p ------------------------------------------------------------------------ swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101 View this thread: http://www.excelforum.com/showthread...hreadid=468842 |
#3
![]() |
|||
|
|||
![]()
A LOT easier formula is:
=SUBSTITUTE(A1," ","") -- Regards, Dave <!-- "JenBasch" wrote: I am trying to figure out how to remove a space between two words in one cell. ex: dog house ---- doghouse Once I figure that out I want it to look through a lot of cells and if they have a space take it out (above) and if not leave it the way it is. Thanks for any help available, Jen -- JenBasch ------------------------------------------------------------------------ JenBasch's Profile: http://www.excelforum.com/member.php...o&userid=27369 View this thread: http://www.excelforum.com/showthread...hreadid=468842 |
#4
![]() |
|||
|
|||
![]()
A LOT easier may be EditReplace
what: space with: nothing Replace all. Gord Dibben Excel MVP On Mon, 19 Sep 2005 09:28:09 -0700, "David Billigmeier" wrote: A LOT easier formula is: =SUBSTITUTE(A1," ","") |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Using 'If' refer to specific words in a cell containing text | Excel Worksheet Functions | |||
how do I fit 2 words into one cell one on top of the other? | Excel Discussion (Misc queries) | |||
Removing a space after a comma | New Users to Excel | |||
Is there a limit to number of words in a cell in excel? | Excel Discussion (Misc queries) | |||
Removing a space within a cell | Excel Worksheet Functions |