Excel To Pagemaker

  • Thread starter Thread starter LU5OM
  • Start date Start date
L

LU5OM

I have compiled a rather large technical bilingual dictionary: 16.000
entries in Spanish, 13000 entries in English, in excel 2000 pro. The
term entry is in column A and the definition or translation is in
Column B.
The printers tell me they need to have the whole dictionary in ONE
column to import it to PageMaker and even so they cannot keep the font
format.
I have tried to do multiple copy-and-paste of column A to B with no
success. As I try to insert, the "paste" sign dimms on me and I cannot
do it. I have done a few hundred entries one by one but it is a
nightmare.
I used two columns because it was easier to read and check. I have some
5000 hours on this book over 4 years.

SUMMARY:
The main goal is to give the printers a full version of my book that
can be imported into Pagemaker for editing, preferably keeping the
format I have in Excel, i.e. bold, italics, font size etc.
If unfeasible how can I do, at least, multiple inserts (column A text
to Column B) to avoid going through the whole book on a one by one
basis.
Could any one please assist me?
Many thanks
 
Do you happen to be a Radio Operator with a callsign of
LU5OM? If so, I am K8DB from Ohio.
 
Since they can't keep the formatting, you could use a helper column:

Insert a new column A and then use this formula:

=A1& " " & b1
and drag down

copy column A and edit|paste special|values and delete the two old columns
(B&C).

(So do this against a copy of your worksheet.)

====
You may want to try this to make it a little more readable.

Insert a new row 1 (after you've inserted that new column A).
In B1, put this formula:
=MAX(LEN(TRIM(B2:B65536)))
(but hit ctrl-shift-enter instead of just enter.
this will give you length of the longest value in B2:b65536.

Then use this in A2 (and drag down.
=LEFT(TRIM(B2)&REPT(" ",$B$1+3),$B$1+3)&C2

I left 3 spaces between columns. Fix both of those 3's if you want more/less.
 
Back
Top