how to use partial (word) search

[Vikky]

Hi;

Can any one help me in putting a formula for partial search (word) in a
coulam or row and result would be the cell value containts that
searched word or value.

Sample Data :

Search : Sathyam

Data:

Sanraj Computers
Santosh Computers
Santosh Enterprises Pvt Ltd
Sap Informatics
Sarthak Systems
Sas Technologies
Sastek Infosys India Pvt Ltd
Satellite Computer Services
Sathyam Computers
Sathyam Computers & Consultancy
Satyasai Information Technology Pvt Ltd
Savithri Digital Computers
Scl India Pvt Ltd
Scott Systems
Sd Info System
Sds Enterprises
Seetaram Computers

Result : Sathyam Computers
Sathyam Computers & Consultancy


Thank you.

Regards


Vikky

 

[Bob Phillips]

See response in .excel

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)