Excel - Concatenate 1

[elfa]

Hello,

I have three columns a b and c. Contents is as follows: a is Car Make. b is Year Make and c is model.

I used the following formula =concatenate(a1,b1,c1) to bring the contents together.

I want to have it all int he same cell but leave spaces between each of the data. I have tried putting spaces in the fomula but this has not helped.

Thanks
Elfa

 

[Gavona]

2 ways to do this:
=a1&" "&b1
or =concatenate(a1," ",b1)

Thanks,

Gavin