Add fixed characters to excel cells in bulk

How to bulk add letters before Excel cells

1. Now I want to add the initials (HY) of Hengyang to each name in the contact column.

2. 3

   I'm looking for column D at the top of my peers. Input formula: = "HY" &A2.

4. 5

   After entering, click Enter. The appearance of "Hy Black rice Brother"

5. 6

   There is not a small square below the cell, press the left mouse button to drag down until the end

6. Remember, you can't just paste the copy you made right now, because this is a formula, not a value. You can use the mouse to click on the above display formula.

   Method One: Paste selectively.

7. method Two: Notepad method. copy and paste the processed data into Notepad.

9. Select all Notepad data, copy. Paste back to the original name section.

10. After pasting, the formula part becomes the hyhy+ name. Indicates the previous value, success! Delete the formula section.

Bulk join fixed characters in Excel cells