LibreOffice Calc Separate Cells Into Comma Separated Values

Use the =TEXTJOIN(",",1,A:A)

This will join all values in the A-column into a single cell separated by ",". You can of course change the value to whatever you like.

Last modified
2020-07-01

Tags

GrN.dk web platforms, web optimization, data analysis, data handling - CSV files, spreadsheets Excel, and logistics.