LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Tina Jones
 
Posts: n/a
Default help extracting data from an excel sheet

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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
make an excel worksheet (sheet 2) open w/ the cursor located in t. animated text in excel worksheet Excel Discussion (Misc queries) 0 February 10th 05 10:29 PM
How to sort/update large excel db [email protected] Excel Discussion (Misc queries) 0 February 2nd 05 12:43 AM
Transfer data from sheet to sheet Jenn Excel Discussion (Misc queries) 4 January 20th 05 03:07 PM
Analyzing non numerical data in an excel spread sheet luckyou_854 Excel Worksheet Functions 1 December 29th 04 10:21 AM
Refreshing Access data in Excel Jimmy G Excel Discussion (Misc queries) 0 December 21st 04 03:53 PM


All times are GMT +1. The time now is 08:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"