Home |
Search |
Today's Posts |
#1
|
|||
|
|||
text search help please?
i have a column of data, both text and numbers and would like to be able to
search for specific words in each cell and separate them onto there own page. example. "159 x 496 green door" "159 x 596 blue door" "720 x 396 green door" i would like to put all the green doors on there own page. all the blue on another ect.ect. the text is not always in the same order. i.e. "door 159 x 496 blue fascia" "720 x 590 red front" ect ect please be patient as i am relatively new to excel. thanks for your help. Phil |
#2
|
|||
|
|||
Hi!
Probably the easiest way is to use a filter. Assume your data is in column A, A1:A100 A1 is a header. Select A1 and goto DataFilterAuto Filter From the drop down that will appear in cell A1 select Custom. In the user form that will appear select Contains from the first drop down on the left. In the box beside that on the right type in some color, say, blue. Click OK Now, only cells that contain the word blue will be displayed. Select those cells and copy/paste them to your other sheet. Repeat this process for each color. When done, to turn off the filter just goto DataFilter and click Auto filter. Biff "phil" wrote in message ... i have a column of data, both text and numbers and would like to be able to search for specific words in each cell and separate them onto there own page. example. "159 x 496 green door" "159 x 596 blue door" "720 x 396 green door" i would like to put all the green doors on there own page. all the blue on another ect.ect. the text is not always in the same order. i.e. "door 159 x 496 blue fascia" "720 x 590 red front" ect ect please be patient as i am relatively new to excel. thanks for your help. Phil |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Text Search Macro? | Excel Discussion (Misc queries) | |||
Fast way to search many cells by column for text strings | Excel Discussion (Misc queries) | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
Search a Column by text length | Excel Worksheet Functions | |||
How do I search for text within text? | Excel Discussion (Misc queries) |