Add the same text in multiple cells
Solved
cymalo
Posted messages
10
Status
Member
-
Fatalizer -
Fatalizer -
Hello
I need to create a rather long list of items. I copied and pasted the dimensions of the items from a supplier catalog and I would like to add a text in front of these dimensions that corresponds to my article code. I cannot use a calculation formula as this list will later be uploaded to another software. I have tried in vain with a macro. Do you have a solution?
Thanks in advance
I need to create a rather long list of items. I copied and pasted the dimensions of the items from a supplier catalog and I would like to add a text in front of these dimensions that corresponds to my article code. I cannot use a calculation formula as this list will later be uploaded to another software. I have tried in vain with a macro. Do you have a solution?
Thanks in advance
3 answers
-
Hello,
In another column, you put the formula:="text"&A1
if your list is in column A, then you drag your formula to the desired length.
You select your column with the formula, copy / paste special / values
and you have your list.
--
Always zen
Perfection is achieved not when there is nothing more to add, but when there is nothing left to take away. Antoine de Saint-Exupéry
