Thanks Ron for your Help.

However i am not able to make it work, i did everything you told me to do
and when i put the formula: =RemBrandPrice(A1) the result is the exact same
information i have in column A1, it dosen't remove the Brand or Price at the
end. I tried this with all the 3900 products and it didn't do anything. What
am i doing wrong?