Searching Multiples Words in cells and returing it in adjacent cell
 

Hi All,

I am new to excel So i have some dat where i need to find and write the manufacturer name,color,Size,material and etc in fifferent cells so i am searching for a formula to search so all the above things and write it in the adjacent cells...for example if the cells has the sentance "Size :Only One Size Bust:92~102CM Across Shoulder:38CM Sleeve Length:59CM Length:75CM Material :Polyester Cotton".so it sould find if the material is Polyester cotton,Cotton,Kint,Sweater or Chiffon and write it wherever needed and same for the other search category.

I would be very thankful to you all,

Thanking you,
Azhar