Hi All,
I've got a small problem that i hope that someone will be able to help with.
Here goes:
I have the following text in a cell: CORPO POM BEANIE
(Corpo Pom is the product name & Beanie is the product)
I want to be able to remove the word 'BEANIE' from the cell by a formula that will look up the word BEANIE from a table of products in another tab and remove it from the cell leaving me with CORPO POM so that i can have just the product name in the cell.
I have attacehed a sample of what im trying to do, The product list is 1000's of lines long so you can see why i would like a formula to do this
Any questions please shout and i will try to help
I am using Excel 2007
Many thanks
Jamie
Bookmarks