ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   field names for print merge (https://www.excelbanter.com/excel-discussion-misc-queries/244553-field-names-print-merge.html)

Robert

field names for print merge
 
I am using Excel 2007 and want to create a .csv file to be used as a print
merge file for Corel Draw x4. At present, Corel reads the text in Row 1 as
field names and I need it to read the text in Column A as the field names.
How do I achieve this?

Jacob Skaria

field names for print merge
 
Cant you transpose the data in ColA and save as .csv.

Copy the cells say A1:A10Select cell B1Right
clickPasteSpecialTransposeOK; and delete Column A

If this post helps click Yes
---------------
Jacob Skaria


"Robert" wrote:

I am using Excel 2007 and want to create a .csv file to be used as a print
merge file for Corel Draw x4. At present, Corel reads the text in Row 1 as
field names and I need it to read the text in Column A as the field names.
How do I achieve this?



All times are GMT +1. The time now is 06:49 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com