How to classify the following paragraphs in excel?

1. Copy it into Word first, and use "p" instead of "."

2.Ctrl+A Select All, copy and paste it into excel, copy the following numbers to column B, and pay attention to enter an English single quotation mark before the numbers. Then press Ctrl+E to fill intelligently. You can also use = right (left (a 1, len (a 1)- 1), 16) to extract.

3. Then enter the formula = left (A 1, len (a1)-len (b1)-2) in column C, and put the mouse on the small black dot in the lower right corner and double-click to fill the formula.

4. If you want to further organize, you can copy and paste column C as the value, delete column A, and do other operations.