If the number has the concept of size or how much, we process the number into numerical format.However, some numbers themselves have no meaning of size and number, just a string of digital codes, then we need to keep the numbers in text format (such as 18-digit ID numbers, codes and other numbers that have no size meaning)

Data Preparation

Observing the above data, the numbers in the 'user id' column are notThere is no size meaning, no operation processing is required, so we can convert it to text format, the method is as follows

1.TEXT function conversion method

Create a new column as an auxiliary column (column F) to store the converted value, enter the formula in cell F2 =TEXT(A2,"@"), where @ stands for text format

Press the Enter key after entering the formula, you can see the converted numerical results, place the mouse in the lower right corner of the F2 cell, when the cross sign appears, double-click to complete the entire column of formula filling

2.Text Connector&

Skillfully use the text connector &, use & to connect an empty value to complete the conversion

Create a new column as an auxiliary column (column F) to store the converted value, enter the formula in cell F2 =A2&" "

Press the Enter key after entering the formula, you can see the converted numerical results, place the mouse in the lower right corner of the F2 cell, when the cross sign appears, double-click to complete the entire column of formula filling

3. Columns

First select the data area, and then select the [Columns] function of the [Data] tab

The "Text Column Wizard" pane pops up, click OK in steps 1 and 2, and step 3 is shown below

The final rendering result is shown below