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