| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to use partial (word) search
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
how to use partial (word) search
See response in .excel
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Vikky" wrote in message ups.com... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Conditional Formatting with Partial name search | Excel Worksheet Functions | |||
| Search for a partial number | Excel Worksheet Functions | |||
| Partial string search w/o VBA? | Excel Discussion (Misc queries) | |||
| Partial search and replace? | Excel Discussion (Misc queries) | |||
| Partial Search using Macro | Excel Programming | |||
Linear Mode
