How to export excel column to comma separated list

how to export excel column to csv

how to convert excel columns into text

how to convert excel column into comma delimited

how to concatenate a column with comma in excel

Combine text from two or more cells into one cell

How To Concatenate Range/Cells With Comma, Space, Line Break In Excel?

STEP 1:

Select a blank cell you will place the concatenation result in, and enter the formula =TRANSPOSE(B1:J1) into it.

NOTE:  B1:J1 represents your column value. Remember to replace the values.

STEP 2:

Highlight the B1:J1 in the formula and press F9 key to replace cell references with cell contents

STEP 3:

Remove the curly braces { and } from the formula, and press the Enter key.

STEP 4:

Copy the contents into any text editor that has search and replace features, e.g notepad++ or wordwrap, then use search and replace to replace double quote with empty

 

If you need more help. Kindly whatsapp: +234-7066623239

Leave a Reply

Your email address will not be published. Required fields are marked *