How to insert text into all Excel fields depending on the value in the same field?

Question

Macros

The bottom line is that you need to insert text into the column following the example:
Column A contains numbers (id)
Column B should be:
Text + value in column A of the same line + text
Can someone poke into the link or show an example script

Answer 1

Your question is similar to the text concatenation function - examples with the CONCAT function can be found here