How to quickly add numbers before text in cells in excel

How to quickly add numbers before text in cells in excel: First open the Excel table that needs to be edited and enter the editing page; then click on the cell behind the text to enter the formula [=ROW(A1)& ","&A1]; Finally, click the left mouse button on the lower right corner of cell B1 and pull down to fill the cell.

The specific steps are as follows:

1. First, open the Excel table that needs to be edited and enter the editing page.

#2. Then click on the cell behind the text to enter the formula: =ROW(A1)&", "&A1, and press Enter to confirm.

#3. Then left-click the lower right corner of cell B1 and pull down to fill the cell.

More tutorials: "Web Front-end Tutorial"

The above is the detailed content of How to quickly add numbers before text in cells in excel. For more information, please follow other related articles on the PHP Chinese website!