Insert text to the beginning of every Cell in a Column
Solution 1:
Create a blank Column (D) and use "CONCATENATE":
=CONCATENATE("0049",C1)
Drag that down for each adjacent cell in Column C and it will add 0049 as a prefix.
Create a blank Column (D) and use "CONCATENATE":
=CONCATENATE("0049",C1)
Drag that down for each adjacent cell in Column C and it will add 0049 as a prefix.