Forum Discussion
adding data to all items in excel
I need to add a government required warning into the long description of all items on a excel spread sheet used in a shopping cart application. The warning needs to include the warning symbol (yellow triangle with exclamation sign), text and a hyper link to a website. How can I make this global addition?
You could use =concat(A1,"⚠ Dont eat these they will make you purple. [http://a.link.com]")
but you cant use that add colour..
Will that add the comment to all items on spreadsheet or is that just for one item. I have 1300 items.
Hia,
If we imagine you have your descriptions in column A (A1:A1300) then in an empty column insert the formula I posted.
Now drag the formula down, you can do this by hovering the mouse over the bottom right corner of the cell with the formula on, the curser will change to a + Either hold down left mouse and drag down or double click and excel will just copy down the column for you.
That will give you all 1300 with the new message. You can then copy/paste values to get the new message without the formula and delete the helper column if you need to keep the order/format of your spreadsheet.
