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.

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.

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.

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.

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.