Re: SOMEONE HELP, please please?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Does this do it

Sub FormatData()
Dim iLastRow As Long
Dim i As Long

iLastRow = Cells(Rows.Count, "A").End(xlUp).Row
For i = iLastRow To 1 Step -1
If Not IsNumeric(Cells(i, "A").Value) Then
Rows(i).Delete
End If
Next i

End Sub

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Tina Jones" <Tina Jones@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5DA25CCD-16F0-4296-8653-FA6D5E299D50@xxxxxxxxxxxxxxxx
> first off thanks you guys for taking the time to help. i have got alot of
> info from the forums. ok here is my latest adventure! i am trying to
create a
> list of phone numbers for my boss. he asked me to pull out every phone
number
> on his phone bills and make a list using excel. now his bills are in PDF
> formatt and i have purchased a PDF to excel converter and it works great,
my
> issue is once im in excel i want to extract or copy all the phone numbers,
is
> that possible? so far ive just been able to delete alot of unwanted text
and
> contect that carries over from the PDF and narrow it down to only 2 colums
(A
> and B) but there is still a few things i dont need like text that reads
> "incomig" ect and ive been deleting row by row and sometimes there are
1200+
> rows and thats just taking way to much time. im thinking there has to be a
> way that once i have all the data in excel i can just copy all the phone
> numbers in the doc? im using office pro 03, can someone help this girl
out?
> thanks


.

Relevant Pages

  • Re: why>?
    ... Just because PDF is more popular than SNP; ... Emailing a dynamic report is easier than emailing PDF files.. ... Excel is ALWAYS less efficient than Access. ... e) multi-user functionality - being able to work on the same report / ...
    (microsoft.public.excel)
  • Re: PrimoPDF verses PDF Creator
    ... modified for both MSWord and Excel. ... "Dave Peterson" wrote: ... I have the latest version of Primo because I only downloaded it yesterday. ... I also need to run a macro to convert a multisheet workbbok to a pdf. ...
    (microsoft.public.excel.misc)
  • Re: From word to Excel?
    ... Word document into an excel format. ... I can receive my 1099B data from my broker as a pdf or as a printed ... F1099b Macro and it should parse things out. ... Dim Str As String, I As Long ...
    (microsoft.public.excel.misc)
  • Re: Save as PDF Add-in
    ... Does it also fail to work in Excel? ... commercial business applications. ... PowerPoint with the functionality of the "Save as PDF Add-in". ...
    (microsoft.public.office.misc)
  • Re: Question on a COM project.
    ... Excel or Word menu bar (after installation like PDF Write or Adobe ... The server side operation will be handled by calling a CGI file ...
    (microsoft.public.dotnet.languages.csharp)