You can decide which character or combination of characters to use to delimit the columns as well as the type of the data in each column. The advantage of this being a wizard and displaying a preview of the data at all three stages means you can simply go back and change the settings if the preview is not how you want the data to be displayed. This wizard allows you to control exactly how exactly how Excel will display a text file You can split a column of data into several columns using the (Data > Text to Columns) command. It is possible to bypass this wizard by holding down Ctrl when you open the text file. If this wizard does not appear then change the file extension to ".txt". When you import a text file into Excel the Text to Columns Wizard should appear automatically.
0 Comments
Leave a Reply. |