1- You must to convert the column data to row data by using copy and paste transpose from the paste options in the Excel 2010.
2- Delete the column data and keep the row.
3- Save the Excel file as CSV (Comma delimited) or Text tab delimited.
Tuesday, December 20, 2011
How to send a column information from MS Excel 2010 to Text file format with (;) separator?
1- You must to convert the column data to row data by using copy and paste transpose from the paste options in the Excel 2010.
2- Delete the column data and keep the row.
3- Save the Excel file as CSV (Comma delimited) or Text tab delimited.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment