Building a Phonebook

J

Jim Berglund

I have a phonebook in Word. I have a phone list in Excel. The list contains
Name, Phone# and is sorted alphabetically by LName,FName as folloes
A B
Bob Allen 403-242-3555
Ruth Axle 403-222-3333
Tom Baxter 403-333-4444
Dave Cull 403-444-5555

I want to break the list up into 26 lists in adjacent columns that I can
then link paste into Word.
for example,

A B C
D E F
Bob Allen 403-242-3555 Tom Baxter 403-333-4444 Dave Cull
403-444-5555
Ruth Axle 403-222-3333 ... ...

Any suggestions on how to do this, Please?
Jim Berglund
 

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

Telephone book 1
Re-structuring contact lists 2
Excel VBA - Inserting associated values in a report Please Help :) 2
Match/ Merge columns 1
IIF statement 3
How to create an if statement to get a multiple result 0
Report Help - Can you do this? 9
Outlook crashes with Outlook connector 2002 0

Top