Remove Space Between Two Words

[Guest]

I am using the following formula:
=CONCATENATE(H4,J4)
The result is for example: Two Blue
What can i add to remove the space between the two words?
I want the result to be: TwoBlue
Thank you for your help,
Bob

 

[JulieD]

Hi Bob

try
=CONCATENATE(TRIM(H4),TRIM(J4))

Cheers
JulieD

 

[GerryK]

Where your result is (eg. A1) you could place a formula
like =SUBSTITUTE(A1," ","") in the next cell (eg. B1).
Also, you can just add the two cells.

 

[Debra Dalgleish]

To remove any spaces: =SUBSTITUTE(H4&J4," ","")