Cancel

Excel create CSV via CONCATENATE function

Posted Jan 13, 2017 2017-01-13T00:00:00+08:00 by PipisCrew

Use this function on first cell, then drag the cell, it will concatenate all rows. Copy the cells to a text file, save as csv.

=CONCATENATE(A2,"|",B2,"|",C2,"|",D2,"|",E2,"|",F2,"|",G2,"|",H2,"|",I2,"|",J2,"|",K2,"|",L2,"|",M2)

src - https://support.office.com/en-us/article/CONCATENATE-function-8f8ae884-2ca8-4f7a-b093-75d702bea31d

#excel #csv

origin - http://www.pipiscrew.com/?p=6444 excel-create-csv-via-concatenate-function

This post is licensed under CC BY 4.0 by the author.

Contents