Solved

Excel Formatting Question

Posted on 2011-03-08
5
201 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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

A little background as to how I came to I design this code: Around 5 years ago I designed an add-in that formatted Excel files to a corporate standard, applying different cell colours and font type depending on whether the cells contained inputs,…
Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This Micro Tutorial demonstrates how to create Excel charts: column, area, line, bar, and scatter charts. Formatting tips are provided as well.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.

773 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