How do I create a name/address/phone 3-column list from Excel work

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Have name,address,phone and date info on Excel 2003 worksheet. Need to put
it in a list much like 3-column labels, but not a label template (without
retyping it).
Any suggestions appreciated.
 
casey

Show us an example of your existing data and how you want the output to look.


Gord Dibben MS Excel MVP
 
In Excel the columns across are: First, Maiden, Last, Street, City, State,
Zip, Phone, Date. I need to make a phone directory out of this information.
If I could change the information to rows, I could cut/paste to make the 3
columns.
Thanks :)
 
You have 9 columns of data?

Which of these 9 do you want included in the new 3-column format.

I take it you want some of the columns combined.

Which will be combined?


Gord
 
You are a quick responder - thanks.
I did a mail merge from Word that worked mostly. I'm cleaning it up now.
If it doesn't end up giving the results I need, I'll let you know.
Thanks again.
:)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Word Create a Phone Book using MailMerge in word 2007 0
VBA - retrieve data on last create named range from previous inserted named range 0
Move rows into columns 3
Importing data from Excel worksheet into Excel template 2
Need of a Database for some "basic" info 1
How to take a list of names & addresses from web site into Excel 4
Auto filter for multiple columns 2
Mail Merge 1

Back
Top