Computer

For Online Computer Support, Ask a Computer Technician

Ask a Computer Expert,
Get an Answer ASAP!

we have a word document with names and address information…

Customer Question
we have a word document...
we have a word document with names and address information that looks like this:
Name 1
Address L1
City1, ST1 Zip1

Name2
Address2
City2 ST2 Zip2

and we want to convert this info to an Xcell spreadsheet with each set of name and address info in a separate ROW (and the City, ST and Zip also separated into separate colums. The headings for the spreadsheet would be as follows:
Name
Address
City
State
Zip

And we do not want to convert one address at a time. Is there a flat fee to get a solution to this. Are we guaranteed a satisfactory solution if we pay?
Submitted: 8 years ago.Category: Computer
Show More
Show Less
Ask Your Own Computer Question
Answered in 6 minutes by:
6/17/2010
Tech Support Specialist: John D, BS Degree in Engineering. replied 8 years ago
John D
John D, BS Degree in Engineering.
Category: Computer
Satisfied Customers: 9,666
Experience: Bachelor of Science - Engineering Consultant
Verified

Hi,

 

The way to do that depends on how the data is listed in your Word document (e.g. in a table, or in paragraphs, or in a single line separated by tab, etc)

 

I would need to see the file to tell you exactly how it should be done. Is it ok to send me the Word file?

 

Yes, you will pay only if you are satisfied with the answer. And that would be by clicking the Accept button that will come up when you get the answer.

 

 

Ask Your Own Computer Question
Customer reply replied 8 years ago

How do we send a copy of the data? We copied some of the data and clicked on the Paste from Word button, but nothing happened . . .

Tech Support Specialist: John D, BS Degree in Engineering. replied 8 years ago

Ok, to send the file go to www.wikisend.com and upload it there. You will then get a page that has the download link (the link looks something like this http://wikisend.com/download/527586/Book1.xls).
Copy the download link and come back here and paste it in your reply.


If the file has sensitive information let me know before you upload it.

 

 

Ask Your Own Computer Question
Customer reply replied 8 years ago
Tech Support Specialist: John D, BS Degree in Engineering. replied 8 years ago

Ok, with this type of arrangement of data it is going to have to be a combination of manual extraction from Word (not necessarily one record at a time) and automated tabulation in Excel.

 

Let me know if you want me to work on this particular file and convert to an excel table. I will also need to see how the fields should be listed in Excel with the column headings (a sample excel file with one or two addresses would be fine)

 

Ask Your Own Computer Question
Customer reply replied 8 years ago
<p>The headings for the Excel file should be:</p><p>Name</p><p>Address L1</p><p>Address L2 (suite)</p><p>City</p><p>State</p><p>Zip</p><p>Phone</p><p>Website address</p><p> </p><p>We need a "procedure" that we can follow for converting ALL the Word documents we have that need to be converted to Xcel. Also, we are having a problem with our computer and would like to re-boot to see if that fixes it.. Irf we re-boot, how do we re-contact you?.</p>
Tech Support Specialist: John D, BS Degree in Engineering. replied 8 years ago

Just bookmark this page, or go to your email inbox and look at the message from JustAnswer.

 

Ask Your Own Computer Question
Customer reply replied 8 years ago
okay thank you we are connected again
Tech Support Specialist: John D, BS Degree in Engineering. replied 8 years ago

Ok, as I said this will require both manual work and a macro. I can of course provide you with the macro but I can not guarantee that you will be able to do it manually in an efficient way.

 

Ask Your Own Computer Question
Customer reply replied 8 years ago
Question #1: Does it take 15 minutes or more to get each answer? We thought when be decided to pay that the communication would be instant. Under the circumstances and the fact that we have spent almost 2 hous and you still havent provided a solution, we must conclude that you have no answer. We are looking for a solution what would be substantially more efficient than a cut and paste method. Either you have a solution or you do not. Please either send the solution OR tell us you have no solution -- NOW.
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a tech support specialistLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask Andy Your Own Question
Andy
Andy
Andy, Computer Consultant
Category: Computer
Satisfied Customers: 5,316
5,316 Satisfied Customers
Experience: 11yr exp, Comp Engg, Internet expert, Web developer, SEO

Andy is online now

A new question is answered every 9 seconds

How JustAnswer works:

  • Ask an ExpertExperts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional AnswerVia email, text message, or notification as you wait on our site. Ask follow up questions if you need to.
  • 100% Satisfaction GuaranteeRate the answer you receive.

JustAnswer in the News:

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
JustAnswer.com...has seen a spike since October in legal questions from readers about layoffs, unemployment and severance.
Web sites like justanswer.com/legal
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

What Customers are Saying:

My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed.

One Happy CustomerNew York

I am very happy with my very fast response. Eric is very knowledgeable in the subject area. Thank you!

RPAustin, TX

Hi John, Thank you for your expertise and, more important, for your kindness because they make me, almost, look forward to my next computer problem. After the next problem comes, I'll be delighted to correspond again with you. I'm told that I excel at programing. But system administration has never been one of my talents. So it's great to have an expert to rely on when the computer decides to stump me. God bless, Bill

Bill M.Schenectady, New York

The Expert answered my Mac question and was patient. He answered in a thorough and timely manner, keeping the response on a level that could understand. Thank you!

FrankCanada

Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help.

Mary C.Freshfield, Liverpool, UK

This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!!

AlexLos Angeles, CA

Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult.

GPHesperia, CA

< Previous | Next >

Meet the Experts:

Andy

Andy

Computer Consultant

5,316 satisfied customers

11yr exp, Comp Engg, Internet expert, Web developer, SEO

Engineer John C.

Engineer John C.

Computer Science Engineer

3,229 satisfied customers

Computer Science Engineer with 10 years of experience in Computer Support, and Microsoft, A+ and Cisco certified

Ryan H.

Ryan H.

Computer Support Specialist

1,741 satisfied customers

A+ Certified Technician - 10 Years experience working with all types of computer systems.

Jane Lefler

Jane Lefler

Sr Prog Analyst / Technician

2 satisfied customers

Computer Programmer / Technician/ Consultant 16+ years

Frederick S.

Frederick S.

Computer Specialist

7,241 satisfied customers

Computer technician and founder of a home PC repair company.

lifesaver

lifesaver

Computer Software Engineer

4,288 satisfied customers

Engineering degree in Computer science,Microsoft Certified Professional.JA computer expert.

Sudipto

Sudipto

Hardware Engineer

4,260 satisfied customers

Certificate Course In Computer Maintenance

< Previous | Next >

Related Computer Questions
Microsoft EXCELL question (I am on MAC iBOOK G4 v. 10. ) I
Microsoft EXCELL question (I am on MAC iBOOK G4 v. 10. ) I download my VISA statement each month in PDF format. I SELECT ALL and PASTE the statement into an EXCELL spreadsheet. I strip off all unimpor… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I have a csv file in Excel Mac 2011, all the data variables
I have a csv file in Excel:Mac 2011, all the data variables (10) are in one column (148 rows, same data variables in each). I need to convert this to a spreadsheet with each data variable in a differe… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
How do I enter a zip code into excel that starts with a 0
How do I enter a zip code into excel that starts with a 0? I currently have one column with street,city and zip codes. I need them all separate. Can i do this without re typing the zipcodes? I have ab… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
Hi. I need help with an issue Im having when I cut and paste
Hi. I need help with an issue I'm having when I cut and paste an address field from Outlook Contacts into Excel. It won't keep the lines of the address together. It put each line into it's own cell, g… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
How do I print an address list from an excel sheet to mailing
How do I print an address list from an excel sheet to mailing labels? I have the columns set up as follows, starting with column B: Last Name, First Name, Street / PO Box, City, State, Zip. (of course… read more
Satchi
Satchi
Bachelor\u0027s Degree
2,103 satisfied customers
Im using mail merge to make labels and my data file which is
Im using mail merge to make labels and my data file which is Excel worksheet is not populating when I merge the data… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I have a text file which I want to convert into Excel. The
I have a text file which I want to convert into Excel. The problem is I need rows to be displayed in columns and columns diplayed in rows. You need to see the file.… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I need to extract just some information from an web page that
I need to extract just some information from an web page that i'm copy and pasting into an excel sheet. I'm familiar with paste special but that still isn't working for what i'm trying to do. Who ever… read more
SergioC
SergioC
Vocational, Technical or Trade Scho
6 satisfied customers
I creating a database in Excel 2002. My problem I do not remember
I creating a database in Excel 2002. My problem I do not remember either the function or formula to reduce the work load. Example. My Clients name will always be in column A in colum B= the civic# & s… read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
I am trying to produce labels in Word. I have filled the first
I am trying to produce labels in Word. I have filled the first sheet and have additional labels to make. How do I go on to a second sheet of labels without starting a new document?… read more
robert
robert
Bachelor's Degree
2,594 satisfied customers
Im trying to print envelopes with address data from an Outlook
I'm trying to print envelopes with address data from an Outlook Contacts file. I need to print in a non-Microsoft program, so am trying to export the data to a csv file. The problem is that the three … read more
J. Mar
J. Mar
IT Specialist
Master's Degree
341 satisfied customers
Anyone familiar with Excel, merging spreadsheets and filtering
Anyone familiar with Excel, merging spreadsheets and filtering specific data (more detailed than the filter option provides)?… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I have a word 2007 document containing a list of addresses,
I have a word 2007 document containing a list of addresses, the number of lines to the addresses vary quite a bit, some have only 4 lines others have 7. i.e. name address 1 city, state zip or it may b… read more
Karl Everest King
Karl Everest King
Web Designer, Programmer
Vocational, Technical or Trade Scho
224 satisfied customers
I have another mailing list to tranfer in excel. John D the ...
I have another mailing list to tranfer in excel. John D the computer expert answered my first question. I would like For John D to answer this one please. I probably need another vb program for this c… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I have a mailing list but the name address and city state ...
I have a mailing list but the name address and city state and zip are all in column A and have a space in between each person. Name address city state, zip then space Name Address city state, Zip Is t… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
I have 500 plus addresses in a column (physical address ...
I have 500 plus addresses in a column (physical address line 1, suite # XXXXX 2 and city, state and zip line 3) and I need to seperate into columns... any advise… read more
John D
John D
BS Degree in Engineering.
9,666 satisfied customers
Is there a program that allows me to drop a name, address
Is there a downloadable program that allows me to drop a name, address and phone number (one hi-lite, copy and paste for all) into a single cell and the program reconfigures each line of info into sep… read more
Hernan
Hernan
Bachelor's Degree
66 satisfied customers
I need help from a Word expert. Its been AGES since ...
I need help from a Word expert. It's been AGES since I've used the mail merge feature. I have a list of addresses (3 lines: first name, last name, address, city, state and zip code. I want to merge th… read more
Glenn F
Glenn F
Web Application Designer / Programmer
Associate Degree
78 satisfied customers
Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Disclaimer: Information in questions, answers, and other posts on this site ("Posts") comes from individual users, not JustAnswer; JustAnswer is not responsible for Posts. Posts are for general information, are not intended to substitute for informed professional advice (medical, legal, veterinary, financial, etc.), or to establish a professional-client relationship. The site and services are provided "as is" with no warranty or representations by JustAnswer regarding the qualifications of Experts. To see what credentials have been verified by a third-party service, please click on the "Verified" symbol in some Experts' profiles. JustAnswer is not intended or designed for EMERGENCY questions which should be directed immediately by telephone or in-person to qualified professionals.

Show MoreShow Less

Ask Your Question

x