• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 211
  • Last Modified:

Excel Formatting Question

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
Joseph Salazar
Asked:
Joseph Salazar
  • 3
  • 2
1 Solution
 
rspahitzCommented:
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
 
Joseph SalazarVice President - Senior IT ConsultantAuthor Commented:
This I know,

How to do it is the Question
0
 
rspahitzCommented:
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
 
Joseph SalazarVice President - Senior IT ConsultantAuthor Commented:
Thanks rspahitz,

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

:)

Cjoego
0
 
rspahitzCommented:
OK...the INDIRECT command can be challenging.  Glad you got it :)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now