ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Convert CVS files on Excel (https://www.excelbanter.com/excel-discussion-misc-queries/181590-convert-cvs-files-excel.html)

rto93

Convert CVS files on Excel
 
How to convert a CVS file to fit columns on an Excel worksheet

OssieMac

Convert CVS files on Excel
 
If you mean csv (not cvs) files then you simply open the file and it should
import without further intervention by the user. You then use 'Save as' to
save it an an Excel file. However, you can get more control over csv files by
changing the file name to .txt and when the txt file is opened, you get the
text to columns dialog box which allows you to apply specific formats to the
columns.
--
Regards,

OssieMac


"rto93" wrote:

How to convert a CVS file to fit columns on an Excel worksheet



All times are GMT +1. The time now is 07:14 PM.

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