Add Space To Cell Sums

[JR]

Hello,

I need to have a space added when combining cells.

Example: A1&B1&C1, but the output I get is 123, but I would like it to be 1
2 3, a space between numbers.

Thanks JR

 

[Peo Sjoblom]

=A1&" "&B1 and so on

Don't know what you mean by Sums? This will be text

 

[JR]

Wroks perfect, Thanks JR

=A1&" "&B1 and so on

Don't know what you mean by Sums? This will be text

--

Regards,

Peo Sjoblom