How to add the same unit or other Chinese characters to a column at the same time

concatenate(a1,"Words or other symbols to be added"For example, if the cell in the first row of the first column is A, and you want to add a "Ah" to the end of A, you can type it in the box to the right of the first column.

concatenate(a,"Ugh")

Just press Enter. I guess your intention is to add words like units, so just copy the format down and add the units to the column. Try it, I don't know if you understand what I said.

Attention, ahh. The outer double quotation marks must be the double quotation marks in the English input state.

Dizzy. The bad ones are deceived and deceived.

How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

Dizzy. The bad ones are deceived and deceived. How to add the same unit or other Chinese characters to a column at the same time

You should be talking about a suffix, right? You can select the cell you want to modify first. Then click on the cell properties, in"Figures"Click on Custom inside the tab, the first one is called"g Common format", you can add what you need at the beginning and end without changing those words.

For example, (g Universal format"kilograms"After you click OK, if the number in the original cell is 100, the content display will automatically change to 100 kg.

I hope mine can help you. Good luck, friend!

Select the column. Right-click to set the cell formatting customization.

00 is entered"Words or other symbols to be added"

Quotation marks are double quotation marks in English.

The 00 in front of you indicates the number of digits of your original number, for example, if it is a three-digit number, fill in 3 zeros to try. Hope it helps.

Customize cell formatting directly.

If column A is a number.

The custom cell format is.

0"Text to add"

Or. "Text to add"

If it's text.

Customize. "Text to add"

Enter the unit or kanji you want to add in column B.

c1=a1&b1

a1&"Words or other symbols to be added"

Here's how to add the same word in front of a column in excel:

Tools Ingredients: Lenovo Legion Y7000P, Windows 10, Excel 2020

1. Select the cells you want to set.

2. Right-click and click Format Cells.

3. On the left, select Custom.

4. Enter the text in the format of "Text@".

5. Click OK to add the text to the front.