text search help please?

[phil]

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

 

[Biff]

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 Data>Filter>Auto 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 Data>Filter and click Auto
filter.

Biff