How excel extracts cells into text

Convert text formats with data columnization:

Select the data source, click [Data] on the menu - Column] - directly click the next point, click three times, and then select Convert the data source to [Text], and click OK.

1. Copy the contents of the cells containing text to the next cells.

2. Adjust the column width to display only one character.

3. Under the "" menu, select "Content Reflow" under "Fill".

4. Select the blank cell next to it to copy, and then select the content that has been split. Right-click and select "Paste Special" from the pop-up menu.

5. Select "Add" in the "Paste Special" window, in fact, this step is to convert the text value into numbers.

6. Then select the split content, and ctrl+g to open the "Positioning" dialog box. and click "Targeting" below.

7. Select "Constant" in the "Targeting" window and select "Text" below it, and finally.

8. In this way, all the cells of the text content are selected.

9. Use Ctrl+"-"The shortcut key, remembered, is the minus sign on the keypad. In the Delete dialog box, select Move Cell Down Up.

10. This achieves the purpose of quickly extracting text.

Select all to copy what you want, right-click in Word to copy only the text.

That's the option for A.

The first way: set the ** box to none The second way: copy the text to word

Select all, copy, then open Word, select Paste Special under the menu, and then select Unformatted Text, so there is no **.

Depending on the location of the specified content, you can choose to use text such as mid or midb, right or rightb, left or leftb, etc. to extract the specified text content.

The following is a detailed introduction and an example of this function:

MID or MID Usage: MID returns a specific number of characters in a text string starting at a specified position, as specified by the user. MIDB returns a specific number of characters in a text string starting at a specified position, as specified by the user.

The midb function can be used for double-byte characters.

Syntax: mid(text, start num, num chars) or midb(text, start num, num bytes).

Parameter: text is the string of text that contains the characters to be extracted. start num is the position of the first character to be extracted in the text, the start num of the first character in the text is 1, and so on; num chars specifies the number of characters you want mid to return from the text; num bytes specifies the number of bytes you want the midb to return bytes from the text.

Example: If a1=computer, then the formula "=mid(a1,3,2)" returns "calculated" and =midb(a1,3,2) returns "sub".

Right or rightb Purpose: right returns the last character or characters in a text string based on the number of characters specified. rightb returns the last one or more characters in the text string based on the number of bytes specified.

Syntax: right(text,num chars),rightb(text,num bytes).

Parameter: text is the string of text that contains the characters to be extracted. num chars specifies the number of characters you want right to extract, which must be greater than or equal to 0. If num chars is greater than the text length, right returns all text.

If num chars is ignored, it is assumed to be the number of bytes specified for the character to be extracted.

Example: If a1=revolution of learning, then the formula "=right(a1,2)" returns "revolution" and =rightb(a1,2) returns "life".

Left or leftb Purpose: Returns the first or first few characters in a text string based on the specified number of characters. This function is used for double-byte characters.

Syntax: left(text, num chars) or leftb(text, num bytes).

Parameter: text is the string of text that contains the characters to be extracted. num chars specifies the number of characters to be extracted by the function, which must be greater than or equal to the number of characters specified by leftb by bytes.

Example: If a1=computer enthusiast, then left(a1,2) returns "computer" and leftb(a1,2) returns "electricity".

<> enter or copy and paste the following formulas in e2.

trim(mid(substitute($d2,"-rept("Squire",100)),column(c:c)*100-99,100))

Right-bucket type noisy pull filling.

The results are all text.

Add +0 or -0 or *1 or 1 to the end of the formula to get a value.

Or. Select column d, column, separator symbols, check Other, and in the text box that follows, Enter-check Consecutive separator symbols are treated as a single process.

Completed before the lease is completed. Delete columns D and E.

My method can do what you want, but I can't do it all in one step.

First of all, you need to divide your original text into columns: Data-Column-Separator-Other(Input), and then it will become the following effect.

Next, enter the formula in the corresponding (or elsewhere) cell below, take the first cell of Hebei Province, the formula =left(b1,find("Province",b1)) Xiong'an County is =left(f1,find("County",f1)) If your text is all in the same province, province, or county, you can copy and paste the first line as soon as you've set it.

Is your actual data format the same as this one, if that's a bit of a hassle.

This is easier to solve with VBA, send me information if you need it, I'll make one for you, no money, pure interest.