Removing Spaces

Good Morning Everyone,

Hopefully someone can help me out. Shouldn't be too hard but I can't figure it out.

I have a formula, and the result is
CAD 38869

There is a space between the string, how can I remove ALL spaces?
I see TRIM, but that will remove all but 1 space... and I need to remove that 1 space.

Thanks in advance.
Stephen

Originally Posted by Solarissf

Good Morning Everyone,

Hopefully someone can help me out. Shouldn't be too hard but I can't figure it out.

I have a formula, and the result is
CAD 38869

There is a space between the string, how can I remove ALL spaces?
I see TRIM, but that will remove all but 1 space... and I need to remove that 1 space.

Thanks in advance.
Stephen

Hi Solarissf,

Try this

=LEFT(A1,FIND(" ",A1,1)-1)&MID(A1,C1+1,100)

oldchippy

Or

=SUBSTITUTE(A1," ","")

VBA Noob

Originally Posted by Solarissf

Good Morning Everyone,

Hopefully someone can help me out. Shouldn't be too hard but I can't figure it out.

I have a formula, and the result is
CAD 38869

There is a space between the string, how can I remove ALL spaces?
I see TRIM, but that will remove all but 1 space... and I need to remove that 1 space.

Thanks in advance.
Stephen

select the range in which your data resides.
press Ctrl+H
in Find what: press space bar once
leave Replace with as it is (i-e empty)
and press Replace All

you are done.
Regards

Thanks Guys,

This Worked