Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Junior Member
 
Posts: 1
Smile 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
Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
compare 2 column cells and return the adjacent columns cells data of the cell trebor57 Excel Worksheet Functions 1 February 1st 11 03:54 PM
Compare 1 cell to column of cells returning adjacent cells info? Mr. Fine Excel Worksheet Functions 1 April 15th 10 07:36 PM
Searching Text that contains particular WORDS. Abdullah Kajee Excel Worksheet Functions 9 August 27th 07 07:52 AM
Excel VBA - Searching long words ozcank[_8_] Excel Programming 4 February 6th 04 05:18 PM
Searching for a words in a column from a list of words. Scott Excel Programming 5 August 15th 03 02:40 PM


All times are GMT +1. The time now is 03:30 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"