biff thank you again for posting. i tried to emai you and i got an error that
the email is not valid, yes i have a one sheet example. where can i send it?

"Biff" wrote:

Hi!

Still working on this?

Send me a copy of your file. NOT the PDF file, the XLS file. Is it 75
sheets? Just send 1 sheet.

XL IS NO help at comcast period net

Don't need IS NO and you should be able to figure out the rest.

Biff

"Tina Jones" wrote in message
...
hi guys, ive been trying to get some help and i already tried going to
other
groups and didnt get an answer that i understood and now my question seems
to
be lost in the wind ;o) i hope someone here can help me. i have an exel
sheet
that has all kinds of data in it. the sheet was a conversion from a PDF
file.
it was a phone bill. what i need to do is find the fastest way to "clear"
or
"delete" all the data and text in the sheet "except" the 10 digit phone
numbers. remember its a phone bill so there are many different phone
numbers
but all have the "-" in the number like this 000-000-0000
ive hear of ways to clear and or delete everything but colums or rows with
"-" in them but i cant figure out how to do that. i dont know how to use
macros, and formulas and VB i just want to clear everything but the phone
numbers. i have 75 sheets to complete so thats why i need the fastest way,
thanks guys!
-Tina