How to add the same text to a column of cells in excel

Open the excel table and select the text that needs to be edited

Click the "Formula" option in the ribbon

Select [Text] function

Find the CONCATENATE function

in text1 Add the text that needs to be added, add the cells that need to be added to text2, and click OK.

Recommended tutorial: excel tutorial

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