How to add fixed text to each cell in excel

How to add fixed text to each cell in excel

1. For example, in front of a column of numbers as shown in the figure Add the text "Baidu".

Recommended: "Excel Tutorial"

　1. Select this column of cells, right-click, and select "Format Cells" ".

　2. In the "Number" tab, click "Customize" in "Category" and enter ""Baidu"#" in the "Type" box on the right.

　3. Click the "OK" button to exit the cell settings.

2. If you add the text "Baidu" before the text, you need to enter ""Baidu"@" in the "Type" box.

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