How to add the same words in excel in a unified way How to add the same words in excel in a unified way

How to add the same words in excel uniformly? When we use the excel table, we will select the C2 blank cell, and then enter = text & B2 to operate. Let this site carefully introduce to users the method of uniformly adding the same words in Excel. Method for uniformly adding the same words in excel 1. Open Excel, click to select the blank cell C2, enter = text & B2, note that the quotation marks must be in English.

2. Press the Enter key to copy the text in B2 to C2, and add the text we want in front.

3. Select cell C2 and other blank rows below, press Ctrl+D to copy the data in column B, and add the same text in front.

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