How to split numbers and text in a table

Splitting text and numbers can be achieved through the left and right functions. Extract the data on the left through the left function, extract the data on the right through the right function, and store the extracted data in different cells to achieve data splitting.

The specific steps are as follows:

1. Open the Excel table that needs to split text and numbers

2. Extract the left side The numerical function =LEFT(A3,2*LEN(A3)-LENB(A3)), change the cells according to your own data, extract the A3 cell, so fill in A3. (When our number is on the right, we only need to change left in the formula to right)

3. Function to extract the text on the right =RIGHT(A3,LENB (A3)-LEN(A3)), change the cells according to your own data. I am extracting cell A3 here, so fill in A3. (When our number is on the left, we only need to change the right in the formula to left)

For more Excel-related technical articles, please visit Excel Basic tutorial column!

The above is the detailed content of How to split numbers and text in a table. For more information, please follow other related articles on the PHP Chinese website!