Text in Row's / Columns Need to Merge

Hello All,

I am looking for a formula that will add to strings of text together from 2 cells.

For example in A2 would be the text "Peugeot 106"
B1 would be the text "1.0 Petrol"

In B2 I would like the formula to display "Peugeot 106 1.0 Petrol"

Using the formula =A2&" "&B1 Works as a one off, but when dragged down seems to add other text. I have tried adding $ but this did not help.

I am using " " in the formula only to get a space inbetween the two words.

Please see example attached that shows the error I get.

Regards in advance, BVG