Expiring Today—Celebrate National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

Excel Formatting Question

Posted on 2011-03-08
5
Medium Priority
?
206 Views
Last Modified: 2012-08-13
I have a Word Document with mailing list on it, but i need it converted to excel.

the format is as follows:

Name
Company Name
Address
City, State zip
phone

How can I import it to the same format but with headings:

Name, Company Name, (Address City, State zip), phone

Cjoego
0
Comment
Question by:Joseph Salazar
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 22

Expert Comment

by:rspahitz
ID: 35075041
Probably the easiest way is to export it as a text file then load it into Excel .  Once it's in, you can write formulas to re-align any of the pieces any way you want.

However, if the data can be saved as a CSV file, then if could be set up to load into Excel pretty much ready to go.
0
 

Author Comment

by:Joseph Salazar
ID: 35075072
This I know,

How to do it is the Question
0
 
LVL 22

Accepted Solution

by:
rspahitz earned 2000 total points
ID: 35075190
did you already export as a CSV?  If so, open in Excel and let me know what's not working.

Otherwise, for a text file, where do the pieces end up?

Something I've done to "transpose" text is below assuming that in Sheet1:

A1=Name
A2=Company Name
A3=Address
A4=City, State zip
A5=phone

Go to Sheet2 and set A1=INDIRECT("Sheet1!A"&(COLUMN()-1)) and copy the formula in A1 across to the right
you can apply similar things for sheet2, A2 and it's row

Does that get you started?

0
 

Author Closing Comment

by:Joseph Salazar
ID: 35117131
Thanks rspahitz,

Took some time to get it right but it worked great !!!!!

:)

Cjoego
0
 
LVL 22

Expert Comment

by:rspahitz
ID: 35125484
OK...the INDIRECT command can be challenging.  Glad you got it :)
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

730 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question