Transfering numbers to Excel database

business_minded

Not sure this is the right place to be posting the ad but hope so..you guys seem to be well up to date.
Im looking for a piece of software that will go through word documents i have and collect all the phone numbers on it and transfer it to a excel sheet.
Basically i have word documents with phone numbers on it, at the moment i am transfering them myself (which takes ages) to an excel spreadsheet. Hope this is enough info please help

kincsem

Is it a name and phone number each line? Its probably a cut from Word, and paste into Excel then.
How many numbers, and how do you want to show them in Excel? Is there a country code, an area code, and a phone number?
I will do it for you if you like, assuming the numbers are not in the millions, and you know what you want. People on here might object to my offer, as it is usual to teach peolpe how to do it, but not to do the work.
My email is my boards name @ eircom.net

Otherwise put a sample of the data in a new post, and we can advise.

business_minded

very kind of an offer, but i would liek to know how to do it also.
they are mainly mobile phone numbers , all i really need is the number transfered no other data with it. could you explain to me how i could do it please

DublinWriter

business_minded wrote: »

very kind of an offer, but i would liek to know how to do it also.
they are mainly mobile phone numbers , all i really need is the number transfered no other data with it. could you explain to me how i could do it please

What I would do is write a small VB application to work through a directory of .DOC files, open them up and search for text starting with '085', '086, '087, then I'd take the next say 10 characters to pick out the full number and paste it into an Excel document.

If you've never programmed before, then forget about doing something like this. You'll be tearing your hair out.

business_minded

well ive never programmed before.. doh.. is there any piece of software you can purcahse?

kincsem

The reason I suggested you post up a sample of data here is ...... we have no idea from your post if the data is one list of phone numbers without text on one Word document, of phone numbers scattered in among text and in a large number of Word documents. Or are the words Phone Number in front of the numbers?

If it a simple list of numbers, one on each line, in a Word document I would hit Ctrl-A to select all the text and numbers in the Word document, hit copy, then go to a blank Excel document, and hit paste. Then in Excel select /Data / Text to Columns, from the menus, and parse the numbers. I assume you want the numbers as text, so select the column as text. Are there any country codes, or area codes, before the phone numbers?

Nobody can provide a solution if you do not detail the problem.

oscarBravo

Nothing to do with Open Source - try Windows or Programming.