Remove all spaces in a cell...

[killertofu]

I am trying to remove all the spaces from a cell so that I can create a
single word. For example, in A1, I have "HOT DOG" then in A2, I would
like "HOTDOG."

The only function I know that comes close to this is TRIM, but that
still leaves single spaces in between.

Thanks for the help people.

 

[Arvi Laanemets]

Hi

Select the range with entries, you want to clean from all spaces. From menu,
activate Replace dialog. Replace all spaces (" ") wit nothing.


Arvi Laanemets

 

[Ron Coderre]

Perhaps this will work for you:

For text in A1

B1: =SUBSTITUTE(A1," ","")

Does that help?

Regards,
Ro

 

[Don Guillett]

have a look at SUBSTITUTE

 

[Dave Peterson]

=substitute(a1," ","")

is one way.

I am trying to remove all the spaces from a cell so that I can create a
single word. For example, in A1, I have "HOT DOG" then in A2, I would
like "HOTDOG."

The only function I know that comes close to this is TRIM, but that
still leaves single spaces in between.

Thanks for the help people.

 

[Biff]

Hi!

Try this:

=SUBSTITUTE(A1," ","")

Or, you could use Edit>Replace and do this in-place and not have to use a
helper cell/column.

Select the cell(s) in question
Goto Edit>Replace
Find what: enter a space by hitting the spacebar
Replace with: nothing, leave this blank
Replace all

Biff

 

[Ken Wright]

=SUBSTITUTE(A1)

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------

 

[Ken Wright]

Would have helped if I included all the damn arguments (Last one is
optional).

=substitute(text,old_text,new_text,instance_num)

=SUBSTITUTE(A1," ","")

Regards
Ken..............

 

[killertofu]

SUBSTITUTE was exactly what I was lookin' for. Thanks people.