| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a list of items in a column? | Excel Worksheet Functions | |||
| How do I create a List in Excel 2000 | Excel Worksheet Functions | |||
| How to create a Sub validation list in excel? | Excel Discussion (Misc queries) | |||
| How do I create an Outlook distribution list from an Excel column | Excel Discussion (Misc queries) | |||
| How do I create a column label in Excel? | New Users to Excel | |||
Linear Mode
