Values in single cell

[Magee]

Hi All,

I have a spreadsheet with different values in the cells between Z to AL

i.e. Z1 says, "tyres", AA1 says "wheels", AB1 says "doors" etc..

Is there an easy way to get all these into 1 cell i.e. Z1 to now say "tyres" "Wheels" "doors" "etc..."

Many Thanks

 

[VoG]

In a spare cell (not Z1)

=Z1&AA1&AB1