Hi Tina,
Posting an example out of PDF may be a little bit further
off track in this case. Though normally failure to post an
example is a major bottleneck in getting a quick answer,
I don't think it applies in this case.

If I understand your problem, you did not need to
purchase software if to copy a single column of telephone
numbers from a PDF file.

You can use the free Acrobat Reader from adobe.com
which basically everyone is forced to install sooner or later.

From my http://www.mvps.org/dmcritchie/excel/pdf.htm webpage.

With the Free Acrobat Reader you have to select one column at a time from the table.
Ctrl+v or look for boxed [T] for Text and use the drop down box to select Column Select Tool (Ctrl+v)
Select the column from the table in acrobat, and paste into Excel. Carefully select the next column so everything lines up with the
previous Column Select and Paste operation.

So yours is a lot simpler, since you only want one column.

Your next problem might be to eliminate duplicate telephone numbers
and for that you might want to use a filter or take a look at
Duplicate And Unique Items In Lists (Chip Pearson)
http://www.cpearson.com/excel/duplicat.htm
or better using a filter see Debra Dalgleish's
http://www.contextures.com/tiptech.html
but I don't see an example, I did a search which turned upturned up
Find & Remove Duplicates - Dedupe Excel Tables / Lists
http://www.digdb.com/excel_add_ins/d...remove_dedupe/
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Bob Phillips" wrote ...
No, write it out in text format in a follow-up post.

"Tina Jones" wrote...
i dont know how to post a sample, can i email you or someone a sample to
see how i can do this? thank you very much!

"Biff" wrote:
Post a good sized representative sample of your data.

Extracting substrings from text entries is usually not too
difficult(most of the time) but we definitely would need
to see a sample of the data.