How to convert column to comma separated list in Excel

hello guys in this video I will show how to convert columns into CSV in Microsoft Excel so there are two formula you can try any

formula first Formula equal sign type text

join now this quotation mark and comma again this double quote and

comma Now here you can select true or false true to ignore empty cells false to include empty cells you can select any option

now

comma and select data closing bracket and press

enter so this way you can convert column into CSV uh second method

equal and type

conate this one

selected and select data now and symbol now this symbol then comma again this symbol and closing bracket so this is the formula press enter so guys as we can see this is the formula to

convert your column

into CSV s you can convert row into CSV using this formula I will show you

example there you

have some data

here you have some data and you want to convert this row into CSV click here type equal

sign C double click on it and select this data then end

now this double quat comma double quat and closing bracket and press

enter so thanks for watching comment this video useful for you.

 

Leave a Comment