Copy table text to Excel worksheet

  • Thread starter Thread starter Regina
  • Start date Start date
R

Regina

I'm using Office XP and am putting text I typed in tables
from Word into an Excel spreadsheet due to the columns
expanding way beyond 11x17, Word's maximum width I believe.
I set up my Excel spreadsheet columns to be wide enough to
accept the text (8 columns across) but after copying, it
put it all in the first column.
Aside from copying each block of text individually, is
there a quick way to do this?
thanks so much,
Regina
 
Hi Regina

yes, select your first column and choose
data / text to columns
you can then choose how your data is separated etc
- if this doesn't work well enough for you, in word, choose your table, then
choose table / convert table to text and set the delimination character that
will work best (e.g. tab) then copy & paste it into excel and then use the
data / text to columns tool

Cheers
JulieD
 
Back
Top