Assuming your 7 digit numbers are true numbers, enter in a helper column:

=(LEN(A1)=7)*(ISNUMBER(A1))

and copy down. Switch on autofilter and remove rows with value 1
--
Gary''s Student - gsnu200731


" wrote:

Hi All!
I have a worksheet containing a column for phone numbers. However,
some of the numbers are missing area codes and are listed in 7 digit
format(1234567) How do I remove the rows that contain the cells in the
phone number column that only contain 7 numeric characters. And
sometimes the imported file will have dashes or paranthesis. I can
remove blank rows, or just blank cells, or cells with specific
characters, but how do you remove the data when each digit can be
different? I was hoping the good ol' "*" key would work, but it only
took out cells that actually contain the "*" character. The only
constant is the number of characters, 7. And be gentle, this is only
my third day working with macros.

thanks!
Cheney