Custom Sorting Of A Column Based On Numbers

Hi guys,

I have a column, G in my Excel worksheet. This column has 600 rows that are populated with the subject lines of emails. Each individual row is a separate subject heading.

Here is my problem. I would like to be able to customize my view so that ONLY rows that contain numbers that are 9 digits long are visible, but I don't know how to do this.

For example, the G4 contains the text "Re: Invoice 929253212". Because this cell has a number, and that number is 9 digits in length, it would return a positive. G5 contains "Help with Invoice 032?" While this cell contains numbers, the number are only 3 digits in length, so they would not be shown in my results. I don't know if this is even possible, but it would save me a ton of time if it were possible, (for this, and for my future sorting needs.)

Does anyone have a solution to this? I have access to Excel 2003 and 2007.

Thanks,

Brian

The number could appear anywhere in the string, the numbers are always positive, and the number could have any mixture of words around it, (remember, these are e-mail subject headers)

Thou art the man. I will try that solution. Thanks!!