Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
I have created a database in Excel that contains only text. Is there any way
that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
Edit Find your particular word
"Jackpine" wrote: I have created a database in Excel that contains only text. Is there any way that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
Yep, and you can use FORMAT: CONDITIONAL FORMATTING to highlight them in a
different colour "Teethless mama" wrote: Edit Find your particular word "Jackpine" wrote: I have created a database in Excel that contains only text. Is there any way that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
Maybe something like this:
Put the search word or phrase in cell A1 Then Select the database range or select from the upper-left cell of the database across to the upper-right cell of the datase and down through Row_65536 with the upper-left cell of the selected range active (Assuming A5 is that cell) Then From the Excel main menu: <format<conditional formatting Formula is: =COUNTIF(A5,$A$1) Click the [format] button and set the highlight Click the [OK] buttons to finish Now..all matched cells in the DB will highlight NOTES: If A1 begins with an asterisk (*).....the match is for "ends with" *widget If A1 ends with an asterisk (*).....the match is for "begins with" widget* If A1 begins AND ends with an asterisk (*).....the match is for "contains" *widget* If A1 DOES NOT use an asterisk (*).....the match is for the entered text widget Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Jackpine" wrote: I have created a database in Excel that contains only text. Is there any way that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
Ron, I don't understand the following from your message:
- why do you mention Row_65536? What is that in reference to? - why do you mention cell A5? - It is not clear to me where I type the word/phrase that I am looking for. Thanks. -- Not all those who wander are lost. J. R. R. Tolkein "Ron Coderre" wrote: Maybe something like this: Put the search word or phrase in cell A1 Then Select the database range or select from the upper-left cell of the database across to the upper-right cell of the datase and down through Row_65536 with the upper-left cell of the selected range active (Assuming A5 is that cell) Then From the Excel main menu: <format<conditional formatting Formula is: =COUNTIF(A5,$A$1) Click the [format] button and set the highlight Click the [OK] buttons to finish Now..all matched cells in the DB will highlight NOTES: If A1 begins with an asterisk (*).....the match is for "ends with" *widget If A1 ends with an asterisk (*).....the match is for "begins with" widget* If A1 begins AND ends with an asterisk (*).....the match is for "contains" *widget* If A1 DOES NOT use an asterisk (*).....the match is for the entered text widget Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Jackpine" wrote: I have created a database in Excel that contains only text. Is there any way that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Search for repeat words in Excel database
OK....here goes:
Q- why do you mention cell A5 A- Since you didn't indicate the range of your data list, I tried to make the instructions easier by creating an example. Q- why do you mention Row_65536? What is that in reference to? A- Since I didn't know how large your data list was, I allowed for it to extend to the last row of the worksheet. So, keeping with my example, if the data list was in columns A through D, the I allowed for the matched items to be anywhere in the range A5:D65536 Q- It is not clear to me where I type the word/phrase that I am looking for A- The method I posted uses Conditional Formatting to highlight matched items. Instead of having you re-select the data list and re-create the condition, I had all CF cells compare themselves to the value in cell A1. So...if you type a value in cell A1, data list cells that match that value will highlight. Post back with any other questions. Does that help? *********** Regards, Ron XL2002, WinXP "Jackpine" wrote: Ron, I don't understand the following from your message: - why do you mention Row_65536? What is that in reference to? - why do you mention cell A5? - It is not clear to me where I type the word/phrase that I am looking for. Thanks. -- Not all those who wander are lost. J. R. R. Tolkein "Ron Coderre" wrote: Maybe something like this: Put the search word or phrase in cell A1 Then Select the database range or select from the upper-left cell of the database across to the upper-right cell of the datase and down through Row_65536 with the upper-left cell of the selected range active (Assuming A5 is that cell) Then From the Excel main menu: <format<conditional formatting Formula is: =COUNTIF(A5,$A$1) Click the [format] button and set the highlight Click the [OK] buttons to finish Now..all matched cells in the DB will highlight NOTES: If A1 begins with an asterisk (*).....the match is for "ends with" *widget If A1 ends with an asterisk (*).....the match is for "begins with" widget* If A1 begins AND ends with an asterisk (*).....the match is for "contains" *widget* If A1 DOES NOT use an asterisk (*).....the match is for the entered text widget Is that something you can work with? *********** Regards, Ron XL2002, WinXP "Jackpine" wrote: I have created a database in Excel that contains only text. Is there any way that I can search for a particular word or phrase in the entire database and have it displayed (by highlighting it for example)? Thanks. -- Not all those who wander are lost. J. R. R. Tolkein |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Print outs from Excel has symbols instead of words | Excel Discussion (Misc queries) | |||
Moved database, how do I change link to the database in excel | Excel Discussion (Misc queries) | |||
import specific fields only from excel to database | Excel Discussion (Misc queries) | |||
Excel list feature should search with more than first character | Excel Worksheet Functions | |||
Spell Checking - Special Words Not Picked Up by Excel | Excel Discussion (Misc queries) |