Microsoft Office

Microsoft Office questions? Ask an IT Expert for support ASAP

Ask a Computer Expert,
Get an Answer ASAP!

I have an existing address list I want to alphabetize how do…

Customer Question
I have an existing...

I have an existing address list I want to alphabetize how do I do that?

Technician's Assistant: What application are you using?

It's a word doc

Technician's Assistant: Have you updated Word recently?

Yes

Submitted: 7 months ago.Category: Microsoft Office
Show More
Show Less
Ask Your Own Microsoft Office Question
Answered in 1 minute by:
1/7/2018
Microsoft Office Technician: Jason Jones, Computer Technician replied 7 months ago
Jason Jones
Jason Jones, Computer Technician
Category: Microsoft Office
Satisfied Customers: 19,460
Experience: Over 10 years work experience.
Verified

Hello,

Is the list in a 'Table' format already?

If you wish, I can remotely connect to your computer and show you how to do this. Otherwise, please upload the document to this page by clicking the Add/Send files button.

Thank you,

***** *****

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
It's attached, but I clicked send and it doesn't seem to have be sent to you
Microsoft Office Technician: Jason Jones, Computer Technician replied 7 months ago

I have the document. Do you wish to alphabetize each address by what is shown on the first line? Do you want to do it by first name or last name?

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
I sent you the document. I do not want to do remote access. I do not want to pay an additional $39. Can you just tell me how to alphabetize this document please.
Microsoft Office Technician: Jason Jones, Computer Technician replied 7 months ago

You may ignore the automatic offer for remote service. Please, answer the questions that I posted above.

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
Yest
Microsoft Office Technician: Jason Jones, Computer Technician replied 7 months ago

Do you want to do it by first name or last name?

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
4 pages 3 columns per page
Customer reply replied 7 months ago
Jane
Microsoft Office Technician: Jason Jones, Computer Technician replied 7 months ago

I am not following.

I have run out of ideas.

For this reason, I am opting out of the question and allowing another expert the chance to help.

The next expert will see all that is on this page, so there will be no need to repeat anything.

When another expert picks this up, you will be notified by email.

Thank you for your patience.

- Jason

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
This is very frustrating Goodbye
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,974
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP
Verified
As the list has multiple columns, what's your preference to sort in colums? By row
, first from up to down then from left to right? Or by column, first from up to down then left to right?
Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
By row
Customer reply replied 7 months ago
By last name
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago
Thanks for the clarification. I will try it.
Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
Thanks!!
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago

I notice you put all addresses in a single, large table with each cell for one address. This way looks well and can control the layout in an easy way. BUT the biggest issue for sorting addresses is, the data is not structural. Therefore Word can't determine which part of an address is the last name. Word is not smart enough to determine.

To re-organise the data in a structural way, you need to use Excel for source data of the addresses. Then in Word, you use Mail Merge to read the addresses data from Excel with all required info structured and separated, e.g. Last Name is ***** ***** field.

This is the correct way to manage structural data with Word, including generating and sorting directory or list.

Where is the source file of your addresses. If they are in an Excel or CSV file, please upload it here, I can help you convert them into Excel sheet.

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
I just wanted to know how to do it. Thank you for your response. I’m good from here.
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago

Okay, may I know if have any existing data source file for your address book? Please upload it here, I can help you convert them into Excel sheet.

If you don't any existing file rather than the given address book in Word, I will generate an example for you and show you what to do. Sounds good for you?

Ask Your Own Microsoft Office Question
Customer reply replied 7 months ago
I'm good thanks, ***** ***** wanted instructions on how to do it! Thanks for your time.
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago

Sure. I am working on generating an address book and writing the instructions.

Ask Your Own Microsoft Office Question
Microsoft Office Technician: bbao, IT Consultant replied 7 months ago

Please see attached an example for the personal address book. The Word file is coming soon.

Ask Your Own Microsoft Office Question
Was this answer helpful?

How JustAnswer works

step-image
Describe your issueThe assistant will guide you
step-image
Chat 1:1 with a microsoft office technicianLicensed Experts are available 24/7
step-image
100% satisfaction guaranteeGet all the answers you need
Ask bbao Your Own Question
bbao
bbao
bbao, IT Consultant
Category: Microsoft Office
Satisfied Customers: 1,974
1,974 Satisfied Customers
Experience: CISM / CISSP / MCSD - Azure Solutions Architect / MCSE - Cloud Platform and Infrastructure / MS MVP

bbao 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

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

I couldn't be more satisfied! This is the site I will always come to when I need a second opinion.

JustinKernersville, NC

Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around.

EstherWoodstock, NY

Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know.

RobinElkton, Maryland

< Previous | Next >

Meet the Experts:

jstinehelfer

jstinehelfer

Information Systems Manager

36 satisfied customers

A+ Comptia Certified computer repair

JasonJames122

JasonJames122

Computer Enthusiast

0 satisfied customers

I manage all information systems (network of Windows PC's and servers with Microsoft Office products) for a small business

Jess M.

Jess M.

Computer Support Specialist

842 satisfied customers

Computer Software Specialist for more than 10 years

The-PC-Guy

The-PC-Guy

Computer Manager

653 satisfied customers

20 years experience providing remote computer support

James K.

James K.

Consultant

260 satisfied customers

Technical Director of IT Company

Kamil Anwar

Kamil Anwar

Office Specialist

219 satisfied customers

8+ Years of Experience. / CCNA (S), CCNA (W), CCNA (RS), MCTS, MBCs.

IT Miro

IT Miro

Computer Scientist

160 satisfied customers

Bachelor's Degree in Information Technology, Microsoft Certified Professional

< Previous | Next >

Related Microsoft Office Questions
I have word 16.1 on a mac, we have uploaded a doc to
I have word 16.1 on a mac, we have uploaded a doc to Onedrive and I want to edit the doc locally and post edits to the Onedrvie doc since it's a shared doc with multiple people. When I right mouse click to open the word doc from Onedrive it does not launch word and open the doc. WHY? … read more
bbao
bbao
IT Consultant
1,974 satisfied customers
Well - I have gone to Microsoft Word, trying to get into WPS
Well - I have gone to Microsoft Word, trying to get into WPS but here is the problem. Document created in WPS on old hard drive; transferred to new hard drive but when I went to open it, it was alphab… read more
Jason Jones
Jason Jones
Computer Technician
19,460 satisfied customers
I have a work book (work book 1) I found that creates a drop
I have a work book (work book 1) I found that creates a drop down list in Alphabetic order. I am trying to incorporate the work book (work book 1) into an existing workbook (work book 2) that I use. W… read more
R. Michael
R. Michael
MIS Analyst
Master\u0027s Degree
22 satisfied customers
I am trying to alphabetize address labels in Word have not
I am trying to alphabetize address labels in Word have not found anything very helpful. Mine is 2010… read more
Richard Hall
Richard Hall
Microsoft Certified Systems Engineer
119 satisfied customers
I worked with The-PC-Guy on a previous question that used the
I worked withCustomeron a previous question that used the same Excel document that I am uploading for this question. I need to have the list changed for a different section in a book that I'm putting … read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have an Excel doc that does not have any macros applied.
I have an Excel doc that does not have any macros applied. I need to have a list of 965 names, credentials, business names, address, etc. changed from the current format to a different format. I can s… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
This question has to do with hyperlinks. I have tried several
This question has to do with hyperlinks. I have tried several times and failed. This is what I want to do: I have ONE MAIN DOCUMENT (REPORT) that needs to reference specific pages in any one of FIVE S… read more
IT Miro
IT Miro
Computer Scientist
Bachelor's Degree
160 satisfied customers
How can I alphabetize open Microsoft Word files? When I open
How can I alphabetize open Microsoft Word files? When I open several Microsoft Word 2010 files (for example files named c,b,a,d and e) and click on the Word icon in the Task Bar they are listed in the… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have office 2007 - for some reason when I go to the start
I have office 2007 - for some reason when I go to the start menu and click on "recent documents" it no longer lists the documents by reverse date - but rather in alphabetical order - so I often can't … read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I use word for mac 2011.Having used Mail Merge for one
I use word for mac 2011. Having used Mail Merge for one word doc, it not only created hyperlinks for that one word doc but it created hyperlinks in EVERY word doc. Looks like: (HYPERLINK:"[email protected]… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I have a word Perfect 12 database. I want to merge it into
I have a word Perfect 12 database. I want to merge it into a list, but the file says (unmodified) which it hasn't been before, and now it won't let me merge it into a list. Help!! My database is a mai… read more
Marco
Marco
Director IT Consultant
Master's Degree
508 satisfied customers
Help create a hyperlink of text to a bookmark in word document?
Greetings, I have a Visio dwg imported into a word doc. The Visio deg has blocks of text in it. I want to hyperlink each block of text to a bookmark in the same word document. So far cannot figure it … read more
Sergio A.
Sergio A.
Security & Technical Specialist
Bachelor\u0027s Degree
395 satisfied customers
I have installed my copy of 2007 Microsoft Small Business on
I have installed my copy of 2007 Microsoft Small Business on my new computer, entered the product key, been using a valuable word document for a couple months, and now the hyperlinks are prevented fro… read more
IT_Help
IT_Help
Network Administrator
Master's Degree
582 satisfied customers
RichieMe I can not get it to list by category in the word doc.
RichieMe I can not get it to list by category in the word doc. It calls up the category and lists it in the data base, but then when I press w and get a wod doc it still gives me the entire list in al… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
Hi - I have MS Word 2007. All of a sudden all my MS Word docs
Hi - I have MS Word 2007. All of a sudden all my MS Word docs were converted to Docx files. How can I convert them back without opening each one and doing a "save as"? Thank you. Stephen… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I need an MS Office Word Expert. I have an existing word doc,
I need an MS Office Word Expert. I have an existing word doc, 2 pages, that I need to turn into a a fillable form/template. By that, I mean I need the fill-in text fields to be open but the rest of th… read more
Richard
Richard
IT Manager
IT Manager, Consultant
3,474 satisfied customers
I am trying to do a mail merge to print labels for our Xmas
I am trying to do a mail merge to print labels for our Xmas card list which I have done every year. I have recently moved onto Windows 7 and Office 2010 since when I am having great difficulties. I ha… read more
The-PC-Guy
The-PC-Guy
Computer Manager
Bachelor's Degree
653 satisfied customers
I have a Gantt chart that I printed as a PDF, and then converted
I have a Gantt chart that I printed as a PDF, and then converted to *.docx but now I want to get it into a word document...!!!… read more
Val B
Val B
Senior Analyst/Trainer
Associate Degree
48 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