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