Searching Multiples Words in cells and returing it in adjacent cell

A

azhar.abidi

Hi All,

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

I would be very thankful to you all,

Thanking you,
Azha
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top