View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Berglund[_2_] Jim Berglund[_2_] is offline
external usenet poster
 
Posts: 86
Default Building a Phonebook

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