Removing spaces from a string

[smalik]

Is there a formula to remove spaces from a string?

For example,
the source data says "Postal Code". How can I convert this to "PostalCode" with a formula. Currently, I am copying and pasting the values then removing the spaces by find/replace. I am sure there is a better way.

Thanks in advance

 

[Eric W]

Try:

=SUBSTITUTE(A1," ","")

 

[smalik]

Try:

=SUBSTITUTE(A1," ","")

It worked... Thank you.

 

[Eric W]

Glad it works for you. Thanks for the update.