Copy table text to Excel worksheet

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Regina - 23 Jun 2004 16:28 GMT

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

Reply to this Message

JulieD - 23 Jun 2004 16:51 GMT

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

> I'm using Office XP and am putting text I typed in tables
> from Word into an Excel spreadsheet due to the columns
[quoted text clipped - 6 lines]
> thanks so much,
> Regina

Reply to this Message