Remember Me?

#1
 JenBasch Posts: n/a
removing a space between words in a cell

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

#2
 swatsp0p Posts: n/a

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)))

A1=dog house returns: doghouse in B1

HTH

Bruce

--
swatsp0p

------------------------------------------------------------------------
swatsp0p's Profile: http://www.excelforum.com/member.php...o&userid=15101

#3
 David Billigmeier Posts: n/a

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

#4
 Gord Dibben Posts: n/a

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," ","")

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post Casino Guy Excel Worksheet Functions 5 August 10th 05 02:02 PM Emzie Excel Discussion (Misc queries) 2 April 21st 05 10:16 PM DebbieK9 New Users to Excel 3 April 1st 05 10:08 PM rampam1 Excel Discussion (Misc queries) 1 January 23rd 05 06:07 PM JERRY8 Excel Worksheet Functions 3 December 2nd 04 03:22 AM

All times are GMT +1. The time now is 03:18 PM.