How do I prepend 2 columns

[aiyoha]

Anyone know how I should "prepend" 2 columns in a spreadsheet with copied cells. Also to Label both columns.

Thanks in advance.

[Pete_UK]

You can use the concatenation operator, &, to join two or more cells together, e.g.:

=A1&B1&C1

Hope this helps.

Pete