[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Excel Formatting Question

Posted on 2011-03-08
5
Medium Priority
?
211 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 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

[Webinar] Kill tickets & tabs using PowerShell

Are you tired of cycling through the same browser tabs everyday to close the same repetitive tickets? In this webinar JumpCloud will show how you can leverage RESTful APIs to build your own PowerShell modules to kill tickets & tabs using the PowerShell command Invoke-RestMethod.

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…
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.
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…

591 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