How to convert excel document into word

[Angel]

I have an excel doc. that I want to convert into word. I don't want the
cells. It seems as if I have to copy each row one by one onto a word doc. I
want to keep the rows info on the rows together but spaced between each row.

 

[Angel]

Thx JoAnn but the tricky part is I have headings, is there a way to get each
heading in front of the text with out copying and pasting each heading in
front of the text

Copy the data from Excel, paste into Word, highlight table, convert table to
text.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I have an excel doc. that I want to convert into word. I don't want the
cells. It seems as if I have to copy each row one by one onto a word doc.
I
want to keep the rows info on the rows together but spaced between each
row.

 

[JoAnn Paules]

If you concatenate the header in the column before you paste it in Word,
that would work but why do you need the header in from of each cell?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Thx JoAnn but the tricky part is I have headings, is there a way to get
each
heading in front of the text with out copying and pasting each heading in
front of the text

Copy the data from Excel, paste into Word, highlight table, convert table
to
text.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

I have an excel doc. that I want to convert into word. I don't want the
cells. It seems as if I have to copy each row one by one onto a word
doc.
I
want to keep the rows info on the rows together but spaced between each
row.

 

[Angel]

Its a roster with members information, SSN...DOB...Names...and so on, so I
needed each header in front of each item...and when you say concatenate...do
I need to copy each header in front of the text in each cell?

If you concatenate the header in the column before you paste it in Word,
that would work but why do you need the header in from of each cell?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Thx JoAnn but the tricky part is I have headings, is there a way to get
each
heading in front of the text with out copying and pasting each heading in
front of the text

Copy the data from Excel, paste into Word, highlight table, convert table
to
text.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


I have an excel doc. that I want to convert into word. I don't want the
cells. It seems as if I have to copy each row one by one onto a word
doc.
I
want to keep the rows info on the rows together but spaced between each
row.

 

[BrianB]

While still in Excel, I'd insert a column in-between each existing column.
Then I'd fill the new columns with the appropriate header value. In other
words, in the inserted column in front of the SSN data I'd fill it with
"SSN:". Then when you copy it to Word and convert the table to text, it will
look the way that you want.

Brian

Its a roster with members information, SSN...DOB...Names...and so on, so I
needed each header in front of each item...and when you say
concatenate...do
I need to copy each header in front of the text in each cell?

If you concatenate the header in the column before you paste it in Word,
that would work but why do you need the header in from of each cell?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"

Thx JoAnn but the tricky part is I have headings, is there a way to get
each
heading in front of the text with out copying and pasting each heading
in
front of the text

:

Copy the data from Excel, paste into Word, highlight table, convert
table
to
text.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


I have an excel doc. that I want to convert into word. I don't want
the
cells. It seems as if I have to copy each row one by one onto a word
doc.
I
want to keep the rows info on the rows together but spaced between
each
row.

 

[Angel]

OH MY!! Thank you Brian, you are a Genius!!!!

Angel!!

While still in Excel, I'd insert a column in-between each existing column.
Then I'd fill the new columns with the appropriate header value. In other
words, in the inserted column in front of the SSN data I'd fill it with
"SSN:". Then when you copy it to Word and convert the table to text, it will
look the way that you want.

Brian

Its a roster with members information, SSN...DOB...Names...and so on, so I
needed each header in front of each item...and when you say
concatenate...do
I need to copy each header in front of the text in each cell?

If you concatenate the header in the column before you paste it in Word,
that would work but why do you need the header in from of each cell?

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"



Thx JoAnn but the tricky part is I have headings, is there a way to get
each
heading in front of the text with out copying and pasting each heading
in
front of the text

:

Copy the data from Excel, paste into Word, highlight table, convert
table
to
text.

--

JoAnn Paules
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"


I have an excel doc. that I want to convert into word. I don't want
the
cells. It seems as if I have to copy each row one by one onto a word
doc.
I
want to keep the rows info on the rows together but spaced between
each
row.