How to exclude numbers in large quantities, how to clear the spaces between numbers in Excel in larg

Here's how to do it:

Step 1: Copy and paste the 3,000 sets of data into a newly created Word document.

Step 2: In the Word document, Ctrl+H opens the Replace dialog box, click Advanced or More, tick Use wildcard, enter :([0-9]@) in the Find box: ([0-9]@) Enter :

1 13, click Replace All. The purpose of this operation is to convert the 3,000 sets of data into one data per row, and if the 3,000 sets of data are already arranged according to the style of one data per row, this step can be skipped. Finally, save this word document as a txt file, for example.

Step 3: Copy and paste another 1,000 sets of data into a new word document, follow the steps of step 2 exactly, and finally save the processed result as a text file. If the original data already has one data per row, skip this step.

Step 4:** File batch processing treasure box, after starting into the main interface, click "More Functions", enter the extended interface, select "Text Line Processing", click "Add Files", load the files into the list first, then add files to the list, enter its function interface again, select the 42nd function, and select the "Update Original File" function option.

Step 5: Click "Execute" and you're done in the blink of an eye.

Step 6: Open the processed file with word, repeat step 2 and enter :(*13 in the Find box.)

1. Note: There are two spaces in front of the comma, and how many spaces there are here, you can decide what it is. Finally, click Replace All, and finally save as.

Step 7: Open the file again and it will become 1112 1114 ..., that is, all the data in and existing in it will be deleted, that is, excluded.

I don't know what you mean, can you go into more detail, do you use the program to exclude or exclude in excel???

You can use conditional formatting, if the data is entered in the A1:C100, select this area, Format, Conditional Formatting, Formula, box.

right(a1)="9"

Next, select a fill color after the condition is established, and you can confirm it.

Let's use conditional formatting, =or(right(a1,1)="9"), and set the color of the cell.

Assuming that the data is in column A, select all data regions in column A, perform Sort, and set the main keyword to column A, in descending order.

Once confirmed, all the spaces automatically run behind the data.

Here's a way to copy this list of ID numbers into a text file. There is no such single quotation mark.

Then import the text into excel in the same way, and this will solve your problem perfectly.

2. Select an empty column and click the Data tab - click the self-text in the Get External Data function group. Select the text file you just want to use and click Import.

3. Pop up the text import wizard dialog box - step 1 of 3, click next 4, in the text import wizard dialog box - step 2, of 3 steps Click Next to come to step 3. Select the text and click Done.

5. The Import Data dialog box pops up, select the imported location cell, and click OK.

6. Final Effect:

1. Let's first create a new excel**.

2, I made a ** casually, click on any cell below the ID card, here it shows that there is a quotation mark in front of the ID card.

3. Click the right mouse button or the shortcut key Ctrl+1 to select [Format Cells].

4. Click [Number] [Text] [OK] in turn.

5. Go back to the original position and delete the single quotation marks.

Suppose the ID number is written in column B, insert a new column C C1 cell after column B to write the formula.

substitute(b1,"'","") or =substitute(b1,"'",) Pull down to copy the formula or double-click the fill handle.

Absolutely simple and reliable!

Click on the column - copy --- paste special - select "Value".

There is no 'in the new target column', and the original column is deleted!

But the target column must be set to "text" format first, otherwise, the large value will become "floating-point"!

If the number is in column a, enter =a1 in b1, press enter, pull down, then copy, and paste the value selectively into column b, there will be no number'number, remember to change the cell format to text formatting, because add'number, is to change the cell format to text, more than 15 digits of numbers, excel will be recorded as scientific notation.

Select the ID card column and set it as text format.

Right-click, Format Cells, Numeric Type, Number of Decimal Places.

The method of removing symbols before digits in Excel in bulk is as follows:

1. Click ** to select the corresponding column. (Select the first column, click a) 2, click [Data].

3. Click [Column].

4. Select [Separation Symbol], and then click [Next].

5. Check [Other], text recognition symbols, select [], click [Next] 6. Select [General] for column data type, and click [Finish].

7. The removal of pre-numeric symbols is completed.

This is a text format marker, generally do not need to be removed, such as ID number, if you go, it will become numerical, if you want to go, you can remove it in the column option.

Copy the symbol you want to remove.

Select the data region to be processed.

Ctrl+F, replace.

Paste the symbol you copied into the lookup.

Click Replace all.

If the symbol of the digital signature is the same, it is very simple, use the find-replace function, copy the symbol directly, fill in the replacement position without filling in anything, and then confirm, all at once. If the symbols are different, it depends on what kind of symbols they are. This is not explicit.

Select the range of cells to be replaced and right-click Press Ctrl+H and type ' in the search box (copy and paste is the safest) Just replace them all!

Please upload a screenshot with a line number and explain your requirements.

Method 1: Use Notepad Find and Replace Function.

Steps: Select all the data and copy it to a blank notepad.

Press Ctrl+H to find and replace the shortcut.

Find the content and fill it in'

Click Replace all.

Then select all the data and copy it to the Excel blank sheet.

Method 2: Use Excel data sorting function.

Steps: Select all the data in this column.

Click on the "Data" tab.

Click on "Columns".

Click "Next".

Delimiter symbol, select Other, and fill in the field'

Then click Next.

Select the cell or range of cells, right-click - "Format Cells", check the "Number" tab, click "Accounting Special" or "Currency" in "Classification", and select "None" in "Currency Symbol" in "Example" on the right

Ctrl+F, select "Replace" (P), enter the symbol before the data in "Find What" (the rest is unchanged), and click "Replace All".

Separate this column of data.

Data --> Column--> Delimiter Symbol--> Text Identifier'

Why can't you change the line?

First copy a symbol before you export the data, directly use the search function on excel, and then paste it, and replace it all with blank, no need to note the notepad or anything upside down.

This is a text formatting guide and does not occupy characters. If you must remove it, there are several ways to do it.

First, select these pure number cells, and an exclamation point will appear on the right side of the cell. Click on the exclamation mark and select "Convert to Number" to get rid of it.

Second, select which row (or column) of pure numbers, then copy, right-click and paste key after an empty row (or column), select "Add" in the paste special, paste, and remove it after pasting. But this is only for common numbers, and if it is a very long number, the last few digits will become 0000 after pasting

Select the cell with the number and press del to delete.

First, first of all, open the excel** program, enter the main interface, and select a Tina yuan to send a letter with a small comma in front of it.

2. Then, in the blank cell position, enter "1" and click to open.

3. Then, select "Format Painter" at the top of the main interface of the excel program and click to open.

Fourth, then, continue to use "Format Brush" to brush the cells that need to remove commas in batches.

5. Finally, you can see that the comma in the excel cell is removed in batches and the problem is solved.

The method of removing symbols before digits in Excel in bulk is as follows:

1. Click ** to select the corresponding column. (Select the first column, click a) 2, click [Data].

3. Click [Column].

4. Select [Separation Symbol], and then click [Next].

5. Check [Other], text recognition symbols, select [], click [Next] 6. Select [General] for column data type, and click [Finish].

7. The removal of pre-numeric symbols is completed.

with columns.

Select the column, click Data, click Columns, select Column by separator, check Multiple consecutive symbols to count as one, click Next, select the columns you don't want, choose not to import this column, and click Done.

Data - Columns, optional fixed column width, next, select "Do not import this column" for the first column, and set the column format for the second column to text.

You can use the Find & Replace feature.

1. Select the one you want to delete'Columns of symbols.

2. Press the CTRL+H shortcut key to open the Find & Replace window. (Or click on the Find function directly on the menu bar and select the Replace option.) ）

3. Find the search content in the pop-up window and fill in one'symbol, replace nothing in the content.

4. Click the Replace All button to remove the ID number in Excel'Symbol.

Absolutely simple and reliable!

Click on the column - copy --- paste special - select "Value".

There is no 'in the new target column', and the original column is deleted!

But the target column must be set to "text" format first, otherwise, the large value will become "floating-point"!

First, the first data is removed'

Manual, that is.

Select the row, double-click, and move the cursor to'

Here, delete it to ensure that the data frame does not have it', then check the box, double-click the Format Painter tool, and copy the format to the line you want to convert.