How to add the same word in front of a column in Excel?

#How to add the same word in front of a column in excel?

The table in the picture; you need to add text before the text in column A: Student:

Steps:

1. Use column B as an auxiliary column;

Select column B, and then enter the formula in the edit bar: "Student:"&A1

2. Press CTRL and press Enter.

The corresponding result will be obtained below.

3. Next, we need to delete column A which is no longer useful;

We can’t just delete it directly; we need to remove the formula in column B. Lose.

Select the data in column B; execute copy,

4. Place the mouse on the selection;

right-click again, and the menu will pop up. Click the Paste as value icon.

#5. Then, delete the formula from the value in column B;

Next, we delete column A, then column B becomes column A.

6. Formula="Student:"&A1

& symbol is a connector that connects characters one after another.

Note that the text must be enclosed in double quotes, otherwise the formula will be invalid and a warning dialog box will pop up.

Recommended tutorial: "excel tutorial"

The above is the detailed content of How to add the same word in front of a column in Excel?. For more information, please follow other related articles on the PHP Chinese website!