I created a simple Concatenate Function

C2, " ", D2, " ", E2

Which worked e.g.

Big Red Apple

I filled that down

and though the formula filled correctly e.g

C3, " ", D3, " ", E3
C4, " ", D4, " ", E4
etc

The values are all

Big Red Apple

I seem to remember this working perfectly before, is there something I am
missing that I am going to slap my forehead about?