Home  >  Article  >  Topics  >  How to add the same text to each column in excel

How to add the same text to each column in excel

coldplay.xixi
coldplay.xixiOriginal
2021-04-14 15:07:53137262browse

How to add the same text to each column in excel: first add "GHI" in the column, and enter the formula "="GHI"&B1" in the cell; then add the desired content at the position of GHI; finally Just hit the Enter key.

How to add the same text to each column in excel

The operating environment of this article: Windows 7 system, Microsoft Office Excel 2010 version, Dell G3 computer.

How to add the same text to each column in excel:

1, as an example, we now want to add the three letters "GHI" to the following columns .

How to add the same text to each column in excel

2. Enter the formula "="GHI"&B1" in the next cell. The position of GHI in the middle is the content you want to add.

How to add the same text to each column in excel

#3, then click the Enter key (also known as the "Enter key" and "OK key") to display the prefixed data.

How to add the same text to each column in excel

#4. Then double-click the small square in the lower right corner of the "D1" cell just now to automatically expand and add the automatic add prefix command to the following cells.

How to add the same text to each column in excel

#5. After completing the above operations, you can get the Excel table with the prefix added.

How to add the same text to each column in excel

Related learning recommendations: excel tutorial

The above is the detailed content of How to add the same text to each column 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