Hello all
I have been banging my head with this for 4 hrs. I have searched all over the net and still can not find the answer.
I have a spreadsheet that is filled with product data ( part number, description prices etc. ). What I want to do is add a 3 letter code in front of their part numbers so when I add this to the database on my server I will know which company owns the products.
Here is an example of what I want. In the column that has the product codes (part numbers) it would show something like this AGP4025 or PTC858 in all of the cells in that column. I want to add PCI- in front of every product code (part number) in the entire column. This is to let me know which company to order the parts from.
How would I do this?
Also on the prices column I would like to add my mark up of a certain percentage to all of the prices in that column. E.G. say 50% to all prices in that column.
How would I do this?
Any help would be greatly appreciated.
I have been banging my head with this for 4 hrs. I have searched all over the net and still can not find the answer.
I have a spreadsheet that is filled with product data ( part number, description prices etc. ). What I want to do is add a 3 letter code in front of their part numbers so when I add this to the database on my server I will know which company owns the products.
Here is an example of what I want. In the column that has the product codes (part numbers) it would show something like this AGP4025 or PTC858 in all of the cells in that column. I want to add PCI- in front of every product code (part number) in the entire column. This is to let me know which company to order the parts from.
How would I do this?
Also on the prices column I would like to add my mark up of a certain percentage to all of the prices in that column. E.G. say 50% to all prices in that column.
How would I do this?
Any help would be greatly appreciated.