Excel to TXT format problem?

In daily study and work, you can use Fengyun PDF converter to convert PDF format, and determine the need to convert PDF documents to Word format, the specific operation steps are as follows:1Double-click to open the software, click the PDF to document function, and drag the PDF document to be converted into the software.

Then, under Fengyun PDF Converter, select the file input format and select *doc option. 2.

After all the settings are completed, click Start Conversion, determine the path you set, and change the file name and save type. 3.The converted Word document can also be reconverted to the original PDF document using Fengyun PDF Converter.

Why don't you batch all the batches in Excel into the desired form first, and then convert them to txt?

If it's just a simple combination like you show, it's easy to convert. Just use the ampers& symbol.

After conversion, copy Paste Special to transpose, which can change from horizontal to vertical.

If you want to be perfect enough to be in a column like you, you can continue to do it with formulas. If the amount is not large, just drag it.

With the help of Word's Find & Replace feature.

You can definitely do it with the VBA inside, but you have to write the content yourself.

I won't be able to do that either. The habitual action is, ctrl+c ctrl+v.

Save as a save type "Formatted text file (space-separated)".

Is that okay?

You try. If not, you describe the topic in detail.

The main thing is that I can't understand the topic. What's your QQ? I'll add that.

The method is as follows: (Computer model: Lenovo G480, system version: Windows7 Ultimate Edition, Excel version:

1. Create a new excel document and open it

2. Click "File" in the upper left corner

3. Find "Open" in the pop-up menu and click:

4. Select "All Files" in the file type below

5. Find the txt file you want to convert and double-click:

<>8. Click Done

9. Conversion successful:

The steps to convert txt to excel are as follows:

Computer: Huawei notebook.

System: Windows 10.

Version: excel365.

1. First, hold Ctrl+C to copy the content of the txt text, and then hold Ctrl+V to paste it into the Excel document.

2. Then, you only need to select the content, select Data-Column, and click Next.

3. Finally, select Other, then enter a comma and click Done.

To summarize as follows: open the txt text file, check whether the data is correct, right-click on the desktop, and select [New - Worksheet].

Open the job**, click [Data - From Text], select the file, and click [Import].

In the text import wizard window, select [Separator - Next], check the options, and click [Next - Finish].

In Excel**, go to the menu bar on the data view, click "From File", select the text, pop up the explorer, select the txt file you want to convert, load the data. The specific steps are as follows:

Tools Raw materials: Mechanical Revolution S3 Pro, Windows10, Excel365.

1. Open Excel**, click on the data on the menu bar, and click "Get Data from File from Text".

2. Open the explorer interface and select the text file you want to import.

3. Click "Load" in the lower right corner of the pop-up dialog box.

4. The data in the txt file is converted into excel** data.

The steps are as follows:

1. First of all, open Excel, select the Data tab, 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.

This can be achieved with one click using the VBA macro in Excel**.

In Excel, it is often necessary to enter data in text, and if the manual input will be displayed too slowly, then the conversion function is needed. Here's how I brought you how to convert TXT to Excel, welcome to read!

How to convert txt to excel:

Txt to ExcelStep 1: First create a new blank Excel**.

Rename "**"; Create a new txt text and rename it to "text";

You can set it yourself, here with " ")

TXT to ExcelStep 3: Open the "**" excel file, click the "Start" menu and select "Open";

TXT to Excel Step 4: File type below the pop-up dialog box.

*All the files, find the "text" file just txt;

TXT to ExcelStep 5: Open TXT"Text"file, the text import step 1 dialog box will pop up, in the "Data Preview" I will see the content of the text, choose to use symbols as separators; Click Next.

TXT to Excel Step 6: Go to the text import step 2 dialog box, and select "Other" delimiter " ", because we used " " as the separator before; Click Next.

TXT to Excel Step 7: This step is selected according to your actual situation, I select "General" here, click "Finish";

The method is as follows: (PC model: Lenovo G480, system version: Windows7 Ultimate Edition, Excel version:

1. Create an excel file and open it

2. Click "File" in the upper left corner

3. Find "Open" in the pop-up menu and click:

4. Select "All Files" in the file type below

5. Find the txt file you want to convert and double-click:

<>8. Click Done

9. Conversion successful: