Current location - Quotes Website - Personality signature - How to add symbols or add the same values after a column of known data in a table?
How to add symbols or add the same values after a column of known data in a table?
Suppose your data is in column B, you first enter "Hefei" in each row of column A, then "Group" in that row of column C, and finally use the formula = a1&; b 1 & amp; c 1
Drag and drop this formula under column D, and you can get the result you want.
Finally, select the whole column of column D, press "Copy-Paste Special Value" to delete the formula, and only the results will be displayed.