Joke Collection Website - Mood Talk - Delete the first number from the excel number.

Delete the first number from the excel number.

Enter the formula =mid(A 1, 2, LEN(A 1)) in b 1, where len(a 1) is the length of A 1 string, that is, how many characters are there, mid is a truncated string function, and mid (.

Then the drop-down formula can be filled.