It will pop up a Convert Text to Columns Wizard Dialog Box.Ĥ. once you select the cell you want to convert Click Data tab choose Text to Columns. Paste the text to your worksheet, and select the cells you want to convert.ģ.
Copy the text you want to convert to columns.Ģ. How to convert a text file to excel in shape of column?ġ. If a text has a name list which have different name and the name differ with commos follow the step 7 and select the option commas the names will be differ as with commas. How to convert a text file to excel which have list of Name differ with commas into different cells? Once you will click the finish your data will be converted to the excel. Now stay with the General option and click finish.ĩ. Now you have text import wizard-step 2 of 3 window stay with tab and then click next.Ĩ. Now you have text import wizard-step 1 of 3 window stay with “delimited” and click the next.ħ. Once you click the next the file conversion window will be open stay with other encodings and click next.Ħ. And then click the next option and choose the file from your computer you want to convert.ĥ. Now select data source it means the from which text file you want to get the data which you want to convert to excel which is show by number 1 in following picture. Once you open the import data option you will find the options choose import data again.Ĥ. And go to the import data option which is circled in following picture.Ģ. Open the Excel spreadsheet where you want to save the data and click the Data tab. Suppose I want to convert the following text file to excel how will I do that.ġ. This article is going to explain that how to convert a text file to excel. However, to get the benefit of it you must know that how to convert a text file to excel. Accumulating as much information as possible into a single software that can be used to get the desired outcomes is a difficult task.īecause of its ability to import data from files with a wide variety of extensions, WPS Excel is a popular choice for this task. A PDF report may be generated by a word application, while data may be generated in the form of a TXT or CSV file by another programme. Data can be generated in a variety of ways depending on the application.
0 kommentar(er)
