How to import text from TXT into EXECL as required

Give 100 points and I'll use VC to write you a small program like this, hehe

There are three ways to import txt text data into Excel.

Excel supports importing text content from external text files. By importing data, we can easily use external data, and in many cases we can avoid the hassle of manually typing text.

There are several ways to import text in Excel, let's take a look at -

1.Use the Open command.

This is the most commonly used method, which can directly open the text file as an excel workbook.

Select the menu command "File|."Open", select File Type as Text File in the Open dialog box as shown in Figure 1, then find the text file you want to import and select it, and click the Open button.

Figure 2 In this dialog box, you can set the original data type, there is a clear explanation on the right side of the options, I will not repeat it here, click the "Next" button to enter the second step setting, as shown in Figure 3.

1. Copy 2. Open the four vertical grids selected by execl and paste them first.

3. Copy this four lines** and right-click to select selective paste, tick the box before transposing, and confirm it.

The dumber thing is to copy it into Word and then copy it to Excel

Copy Open Excel from Word and select Transpose from the Right-click Paste Selector option.

Guided like this? I won't, I'll only lead...

The steps are as follows: 1. First, open Excel, select the Data tab, and the Self Text option.

2. In the pop-up explorer interface, select the stored txt file and click the open button.

3. At this time, the text import wizard pops up, since my numbers are separated by spaces, so I choose the separator symbol, of course, if your text is a fixed width, you can choose the second one. Then click on the Next button.

4. Check the space to check whether the preview data is consistent with your expectations. Once consistent, proceed to click on the Next button.

5. Check the preview effect. And select the column data format, there is no special requirement here, it is recommended to choose the regular, the general is also the default format of excel. Click Done.

6. In the pop-up dialog box, select the data area you want to import, here I want to import to the current cell, and start from the A1 cell, so I select the A1 cell, and the excess data will be automatically opened to both sides with this cell. Click the OK button.

Our data is perfectly imported.

Method 1: Import text data:

1. Open Excel2016, find "Data" in the menu bar, click the inverted triangle of "Get External Data" in the toolbar below "Data", find the "Self Text" icon, and click;

2. Select the data text you want to import and click "Import";

3. Enter the text import wizard, select the file type, generally select the separator symbol, of course, you can also choose whether to split the symbol or fix the width according to the way you text, and then click "Next";

4. Select the type of split symbol, tab, semicolon, comma, space or other, you can see the data effect in the data preview, and click "Next" after setting;

5. The column data format directly adopts the default settings, click Finish;

6. In the pop-up import data box, set the location of the data, you can use the existing worksheet or the new worksheet, and then click "OK" to see the import effect in Excel.

<> Method 2: Other ways.

1. In addition, there are other ways to import external data, such as importing **data, you can set up the import in "Data", "Get External Data" and "From**";

<>2. To import database data, you can select the database type in "Data", "Get External Data", "From Other", and then set the import;

When using Excel, you often encounter situations where you want to combine with other files, such as Word and TXT, and today I will talk about how to import TXT files in Excel.

Step 1: Determine where the txt file you want to insert is so that you can find it later. Find the menu single-column data - from text - comes out as follows: Select Text Position dialog box - Select - open.

Step 2: Text Import WizardStep 1 - Select the delimiting symbol.

Step 3: Text Import Wizard Step 2 - Select "Treat Consecutive Separated Symbols as a Single Process".

Step 4: Text Import WizardStep 3 - Text.

Step 5 - The data location dialog box appears, you can select it according to your needs, click OK.

Finally, you can see the complete txt import renderings

Data - Import External Data - Import Data - Select Your Text File - Open and select "Delimited Symbol" under the original data type in the Text Import Wizard dialog box - Next, check "Other", and enter a "-" on the right to mean that you will press "-" to sort the columns, and you will finish; Then select the location where the data is stored (the default is the location of the A1 cell of the current worksheet as the first data imported), OK. Next, because there are many - signs between A and B in your original text, the extra - signs will occupy a space after importing, it doesn't matter, operate again: select the line number (the left one, etc., depending on how many rows your data has, select how many full line numbers), and then press the F5 key - Positioning Condition - Null - OK, so that all the empty cells will be selected, at this time, the right mouse button - delete - the right cell left shift - OK.

OK, you're done!

Software version: Office 2013

Here's how:1Click "From Text" in the data menu

3.The import wizard can be set up, and if it is set by default, you can simply click "Done":

4.Select a placement location and click OK:

1.A laptop.

2.Software Excel 2010.

3.A txt text file containing data.

1.Prepare a txt file and Excel** and place it on your desktop.

2.Open an Excel in Excel 2010 and select Data-Self-Text.

3.Select the text file on your computer.

4.Click the Done button.

5.Click the OK button.

6.Review the data.

Click the [From Text] button under [Data], and the button positions are as follows:

Data - Import external data - Import data - Select txt file - Split symbol and select other inputs", "Done.