Column to text

[WGBarry]

I have 5 columns in a workbook Place, date, time, name, score I would like to move them all into 1 column and be separated by , is there an easy way of doing this?


Best regards

[Spencer101]

Assuming your 5 columns are A to E, and starting in row 1, you could just use =A1&","&B1&","&C1&","&D1&","&E1 and copy down. Then "Paste Special / Values" over the top of this new column.

[Tony Valko]

You could do something like this...

Assuming the data is in the range A1:E1
Enter this formula in F1:

=A1&", "&B1&", "&C1&", "&D1&", "&E1

Copy down as needed.

[WGBarry]

Much appreciated, the only problem is the date column has become a 5 digit number and time a massive decimal number?

[Spencer101]

How about....

=A1&","&TEXT(B1,"dd/mm/yyyy")&","&TEXT(C1,"hh:mm")&","&D1&","&E1

[WGBarry]

Fantastic Spencer, thank you very much!

[Spencer101]

Not a problem. Happy to help

[Tony Valko]

Like this...

=A1&", "&TEXT(B1+C1,"d/m/yyyy h:mm")&", "&D1&", "&E1