Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
i have a excel file in CVS format how i can convert it into XLS and put every
value in seperate cell. |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Rename the file so that it has an extension of .txt, then with Excel
running use File | Open and browse to the folder and point to the .txt file (you will have to change the File Type box to All files *.*). Excel will automatically start the Data Import Wizard, in which you have a lot of control over how the imported data is to be treated. Alternatively, import the file into one column (presumably that is what you are doing now) and use Data | Text-to-Columns to split the data up. Hope this helps. Pete On Nov 26, 8:53 am, elhossan wrote: i have a excel file in CVS format how i can convert it into XLS and put every value in seperate cell. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how will i convert 05.01.2007 convert 05.Jan.2007 format? | New Users to Excel | |||
convert number to its letters ( convert "1" to "One" ) | Excel Discussion (Misc queries) | |||
convert value in word. For Exampe Rs.115.00 convert into word as . | Excel Discussion (Misc queries) | |||
convert decimal number to time : convert 1,59 (minutes, dec) to m | Excel Discussion (Misc queries) | |||
Convert Time...!convert tenths of a second | Excel Discussion (Misc queries) |