Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default How do I create a name/address/phone 3-column list from Excel work

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I create a name/address/phone 3-column list from Excel work

casey

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 20:46:02 -0700, casey
wrote:

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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default How do I create a name/address/phone 3-column list from Excel

In Excel the columns across a 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 :)

"Gord Dibben" wrote:

casey

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 20:46:02 -0700, casey
wrote:

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.



  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 22,906
Default How do I create a name/address/phone 3-column list from Excel

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

On Sun, 30 Jul 2006 08:04:01 -0700, casey
wrote:

In Excel the columns across a 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 :)

"Gord Dibben" wrote:

casey

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 20:46:02 -0700, casey
wrote:

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.




  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 80
Default How do I create a name/address/phone 3-column list from Excel

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.
:)

"Gord Dibben" wrote:

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

On Sun, 30 Jul 2006 08:04:01 -0700, casey
wrote:

In Excel the columns across a 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 :)

"Gord Dibben" wrote:

casey

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


Gord Dibben MS Excel MVP

On Fri, 28 Jul 2006 20:46:02 -0700, casey
wrote:

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.






Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How do I create a list of items in a column? stepaim Excel Worksheet Functions 3 May 6th 06 07:07 PM
How do I create a List in Excel 2000 Watch Online Excel Worksheet Functions 1 January 31st 06 07:45 PM
How to create a Sub validation list in excel? Simon Excel Discussion (Misc queries) 1 July 13th 05 10:31 AM
How do I create an Outlook distribution list from an Excel column Mike Officer Excel Discussion (Misc queries) 2 June 24th 05 04:45 AM
How do I create a column label in Excel? Annette New Users to Excel 1 February 21st 05 06:44 AM


All times are GMT +1. The time now is 08:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"