How multiple excel cells into the same unified text? ?

I use the caption as input number is very simple, so they first enter the number that the diameter of the code before the DN to how to operate, can be unified into? Seeking skilled are help! ! I am only 30 Caifu Zhi, all used to ask questions, Thank you very much.

At the back add a secondary column, B1 enter the formula after the drop-down, if column A is your original, = “DN” & a1 selected after the completion of this column All – Copy – Right – Paste Special – select the original column A, paste complete, remove the supporting columns

Thank you, the master first answer, I'm done! Thank you!

File send over, to help you!

This is not what the

to use the formula = “DN” & a1 to drop down to the formula into the text, select the copy of this column – right Paste — — — determine the value of can

If you enter a number in column A, column B, the formation of the format you want, then OK your way in the B column on the use of the formula:= “DN” & A1, copy the following become.

1, enter the complete figures, in another column with the formula = “DN” & A1, the drop-down, then copy this column, Paste Special as values can be replaced after the original figure out the .2, set the cell formatting custom ” DN “#, direct input of 25 is displayed as DN25.