Solved

Excel Formatting Question

Posted on 2011-03-08
5
200 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
  • 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 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Sparklines have been introduced with Excel 2010 and are a useful tool for creating small in-cell charts, used for example in dashboards. Excel 2010 offers three different types of Sparklines: Line, Column and Win/Loss. What it does not offer is a…
Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvie…
The viewer will learn how to create two correlated normally distributed random variables in Excel, use a normal distribution to simulate the return on different levels of investment in each of the two funds over a period of ten years, and, create a …
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.

932 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now