merging rows of data ?

[aaronep]

I have Windows XP, Excel Vsn 2002. I have created an Excel file of 37
rows, one cell (cell A) on each row.

Would it be possible to merge the rows together so that more than one
row will fit on a single line of text? I would like to put all of
the data into a single Msft Word paragraph, if possible.

All replies welcomed! Aaron

 

[Wild Bill]

It's lame, but if you hear of nothing tighter,
Copy the column
paste special / transpose to A2 or somewhere
copy that
paste to Notepad
copy again (Ctrl-A, Ctrl-C)
paste to word
That's at least 9 keystrokes with 1 or more clicks - weak but effective.

 

[Rick Rothstein \(MVP - VB\)]

I have Windows XP, Excel Vsn 2002. I have created an Excel file of 37

rows, one cell (cell A) on each row.

Would it be possible to merge the rows together so that more than one
row will fit on a single line of text? I would like to put all of
the data into a single Msft Word paragraph, if possible.

Assuming you mean you want to take the contents of A1 to A37 and concatenate
them all together into a single string of text (perhaps separated by a
single blank space), try the following. In B1 place this formula...

=A1

In B2, place this formula...

=B1&" "&A2

notice the separating blank space; if you don't want it, remove it (and one
of the ampersands). Now, copy B2 down through to B37. When done, the
contents of B37 will be the concatenation of the data in all the cells from
A1 through A37. If you make any changes in any of the cells in A1:A37, it
will be reflected in the concatenated string of text in B37. Next, open your
Word document, select B37 and edit/copy it, switch to your Word document and
select edit/paste from its menu.

Rick

 

[Jerry]

I had this same "issue" at one time. I went to the Web and downloaded an
Add-in called ASAP. I don't recall where I obtained it, but if you
"Google" something like Excell addin ASAP, you should be able to find it.
This Add-in is great. I suspect you'll love it.

 

[aaronep]

Note to Jerry, Wild Bill, & Rick: Thank's to Jerry's post, problem
has been solved.
I downloaded a program called ASAP UTILITIES written by Bastien
Mensink in the Netherlands.
I chose a utility called "merging rows", and it worked perfectly.
Needless to say, my appreciation for your quick replies is PARAMOUNT.
100,000 Thank Yous! Aaron

**************************************************************************************************************8