Home |
Search |
Today's Posts |
#1
|
|||
|
|||
need short cuts in the find option
I no that there are short cuts when using the find option. example i want to
find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL |
#2
|
|||
|
|||
maybe looking for
*core will help you find all the cells that contain values that end with CORE. The asterisk is a wildcard. Trisher75 wrote: I no that there are short cuts when using the find option. example i want to find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL -- Dave Peterson |
#3
|
|||
|
|||
*CORE
#s* -- Regards, Peo Sjoblom "Trisher75" wrote in message ... I no that there are short cuts when using the find option. example i want to find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL |
#4
|
|||
|
|||
thank you that worked.
"Dave Peterson" wrote: maybe looking for *core will help you find all the cells that contain values that end with CORE. The asterisk is a wildcard. Trisher75 wrote: I no that there are short cuts when using the find option. example i want to find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL -- Dave Peterson |
#5
|
|||
|
|||
the * worked.. not to sure what you mean by the #s*????
"Peo Sjoblom" wrote: *CORE #s* -- Regards, Peo Sjoblom "Trisher75" wrote in message ... I no that there are short cuts when using the find option. example i want to find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL |
#6
|
|||
|
|||
I thought you wanted the beginning of words as well starting with #s
-- Regards, Peo Sjoblom "trisher75" wrote in message ... the * worked.. not to sure what you mean by the #s*???? "Peo Sjoblom" wrote: *CORE #s* -- Regards, Peo Sjoblom "Trisher75" wrote in message ... I no that there are short cuts when using the find option. example i want to find everything at the end of the text in a cell like the word CORE and the begining of every word is something difrent like #'s. I no that you can insert something so that it will look at the end of it... does that makes sence???? arrggg i hope so LOL |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Filter option | Excel Discussion (Misc queries) | |||
Using the Find tool in EXCEL | Excel Worksheet Functions | |||
UDF and Calculation tree | Links and Linking in Excel | |||
Excel has a "Find Next" command but no "Find Previous" command. | Excel Discussion (Misc queries) | |||
Status Bar - Key Board Short Cut | Excel Discussion (Misc queries) |