Searching in excel like google???

**sajidbagi** · 10-09-2009, 03:14 AM

i want to search the all the words i insert in cell .......for the time being my attached file can only search the word or letter i type in a cell as it is.but i want to search like google for instacnce i type pvt (pvt).if it exists in database it search for both of the words from data base.for more details please see the attachment.

**HammerTime** · 10-11-2009, 09:27 PM

sajidbagi,

Could you just use Ctrl + F to search your database?

**sajidbagi** · 10-12-2009, 02:50 AM

i want my data presentable. by using ctrl+f it will not be printable as well but the method i m using for the time being is a best thing for me till data but i want max data search able at a time.

**teylyn** · 10-12-2009, 03:05 AM

i want my data presentable.

can you please supply a workbook with an example of what you would like to see and use plain, understandable English terms to describe the logic of how you would want Excel to arrive there?

**sajidbagi** · 10-12-2009, 03:29 AM

now i have attached a file..in this file i m giving an example that if i m putting in the search box "searching text in excel" it searches for all the word from the database separately and highlights as well.

but in my sheet that i attached earlier i m not able to search like this..it searches on the text as it is put into the search text box.

lets say: if i searches in google " america is a big city" it will not only search for amerca is a good city but will search america , is , a , big , city separately.