Add the same text in multiple cells
Solved
cymalo
Posted messages
10
Status
Membre
-
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 réponses
Hello,
In another column, you put the formula:
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
In another column, you put the formula:
="text"&A1if 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
thank you very much