LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 16th 12, 07:37 PM
Junior Member
First recorded activity by ExcelBanter: Jan 2012
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,

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 05:31 PM.

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

About Us

"It's about Microsoft Excel"


Copyright © 2017