Combine Text with Numbers with no spacing

Hi All,
this probably simple, but im stuck here.

What i want to do is just to combine eg, A 12345 to A12345, (eliminate spacing to & from single cell).

Thank-You very much

Hi AliGW,
That was fast , actually i am aware for the replace, perhaps to rephrase my question, is there a formula for doing this?

Thank-You very much

Hi again, AliGW,

I see... I will just use the replace instead.
will mark Solved for this thread.

Thank-You very much

Hi there,
Assuming your cell with the' a 124' is in C#, a formula to remove spaces: =SUBSTITUTE(C3," ","") = 'a123'

you can use a formula but the result will be in another cell

=SUBSTITUTE(A1," ","")

Hi, ORoos, davsth

Yes! thats what i was looking for... without knowing this can be done from a formula.
Will add reputation to you both.

Thank-You very much

Hi AliGW,

My mistake, i have rephrase my question to the next comment. Ill be more precise next time..,
I am thanking you too for the attention.

Thank-You very much