Home  >  Article  >  How to quickly add numbers before text in cells in excel

How to quickly add numbers before text in cells in excel

卡哇伊
卡哇伊Original
2020-07-16 16:11:0028291browse

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.

How to quickly add numbers before text in cells in excel

The specific steps are as follows:

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

How to quickly add numbers before text in cells in excel

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

How to quickly add numbers before text in cells in excel

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

How to quickly add numbers before text in cells in excel

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!

Statement:
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn