Excel columns problem

  • Thread starter Charlie Johnson
  • Start date
C

Charlie Johnson

I'm trying to create a phone book for company. The delimited data
comes in an Excel file which converts to 1500 rows of 3 columns. I
copied into Word and used the newspaper columns feature to place 2
sets of columns of data side-by-side. Except, Word chokes when it
tries to distill this to PDF. And, what pages actually display in PDF
appear too slowly. I watch one column of data display downward, and
then the next, and so forth. Users won't wait that long to find a
phone number. I also tried copying the Word newspaper columns back
into Excel but ended up with one set of 3 columns of data.

Excel exports to PDF cleanly and displays quickly in PDF. Is it
possible to format 3 Excel columns of data into two sets of 3 columns
per page? I've seen some older postings here but curious if anything
new has been discovered?

Thanks,
Charlie
 
J

Jim Cone

Hi Charlie,

Re: "...possible to format 3 Excel columns of data into two sets of 3 columns per page?"

My Excel add-in "Side by Side" will do that.
It's fast and easy to us.
It is available - free - upon direct request.
Remove xxx from my email address.

Regards
Jim Cone
San Francisco, CA
(e-mail address removed)
 
J

Jim Cone

Charlie,
....and the program, via email is on the way to you.
Jim Cone\

Charlie Johnson said:
Thanks Jim - an e-mail is on the way.
Charlie
charlie6067
-snip-
 
C

Charlie Johnson

I want this group to know that Jim's add in completely solved my
problem of replicating Word's newspaper-type columns in Excel. It was
simple to install and I can put 2, 3 or 4 columns of data on a page.
This add in saved me over an hour of cut and paste withough worrying
that some data was left out.

Thank you Jim!
Charlie
charlie6067
 

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

Top