How to export each line in Excel as a txt text

Press alt and f11 at the same time to enter the macro interface, click on the insertion of the menu, module, paste as follows**:

sub test()

dim i, totr as integeron error goto line1

falsefalse

totr = range("a65000").end(xlup).row

for i = 1 to totr

rows(i).copy

range("a1") &".txt", xlunicodetextnext i

line1: = true

trueend sub

Run this macro directly by pressing F5 on this interface, and you're done.

**Not verified, let's try a simple example at the end. The file should be saved in the excel file path.

Save the contents of each column of Excel as a separate txt question.

There is an excel document, you need to use the column header of each column as the name of the txt document, and the content below the column header is the content of this document. If this excel document has 10 columns, the file that needs to be saved is: content is a2 a3 content is b2 b3 content is c2 c3 content is d2 d3 d4 wrote a paragraph**, but this ** can only save a few files to appear:

Runtime Error 52 Wrong file name or file number! I checked the header of each column and there are no double quotation marks in it ("), apostrophe('), slash ( ), backslash ( ) colon (:) vertical bar (|And the file name is set to less than 255 characters.

But this is still the case. The ** used at that time was as follows:

sub daochu()

dim i as integer, j as long, rw as long

for i = 1 to

open & "" & cells(1, i) &".txt" for output as 1

for j = 2 to cells(65536, i).end(3).row

print #1, cells(j, i).value

next j

close 1

next i

msgbox "Data export complete! ", vbokonly, "The export was successful"

end sub

The screenshot is as follows:

Import data into Excel with Import Data.

1. Click on the data - self-text. Find the text file and click Import.

2. In the text import wizard default next step, enter the second step, select the text separator according to the actual situation, there is no system preset separator, you can enter the separator.

3. Select the column data format for the imported data, you can select general, date, text, etc., select text here.

4. Click Done, specify the save location in Excel for the imported data, and the import data is completed.

Hello, the specific operation is as follows:

Open Excel**, click on the "Data" tab, and in "Get External Data", find "Self-Text".

The text import dialog box pops up, select the default fixed width, which means that the data corresponds to the cells one by one. If you select a delimiter, all imported data will be in one cell. Next, click Next.

For detailed steps, please refer to the experience.

You can use VBA to achieve what you want.

Start by opening a text file with data. Text in text can be horizontal or vertical.

Open Excel**, copy the text from the text file to the excel sheet, all the text is in one cell, select this cell.

The WPS Office version is used, and Microsoft Office 2007 is the same.

Then step by step, the data is divided into columns and dividing symbols and spaces are completed.

And that's it.

Are there any actual documents?

I read your **, it is a bit difficult to achieve what you want by directly importing txt, because the content of the cde column is inseparable by a separator, it is recommended to import txt first, and then use the formula to implement the content of the cde column.

If it is a 2010 version, there is a function to import external data in the data.

You can import hundreds of txt files directly into an excel file, and then arrange them in the format of one txt for one row.

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.

After simple processing, it can be displayed in three columns.

1. Content. 2. Time.

3. Username.

The first is to replace the txt three times before importing.

1. Delete all the spaces.

2. Replace "2014" with.

3. Replace the colon with.

Space. Execute the Text Import Wizard.

Separator selection. Space.

It is possible to divide the time into three segments.

Sort it out yourself.

Get your feet wet?

If the column symbol in the text is a comma, you can open it directly in Excel.

If there is no column symbol, you can open it in Excel and proceed later.

Breakdown. Operate.