Hi, I have a long list of values in columns, I would like to concatenate the list (without manually selecting each value) and insert a semi colon between each value eg cell A1 (1113159), cell B1 (H13159), cell C1 (WD 12 X (UK)). I would like the output to look like this : D1 1113159;H13159;WD 12 X (UK)