merging rows of data ?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aaronep@pacbell.net - 08 Sep 2007 02:27 GMT

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

Reply to this Message

Wild Bill - 08 Sep 2007 07:46 GMT

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.

>I have Windows XP, Excel Vsn 2002. I have created an Excel file of 37
>rows, one cell (cell A) on each row.
[quoted text clipped - 4 lines]
>
>All replies welcomed! Aaron

Reply to this Message

Rick Rothstein (MVP - VB) - 08 Sep 2007 10:14 GMT

>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

Reply to this Message

Jerry - 08 Sep 2007 11:27 GMT

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.

> I have Windows XP, Excel Vsn 2002. I have created an Excel file of 37
> rows, one cell (cell A) on each row.
[quoted text clipped - 4 lines]
>
> All replies welcomed! Aaron

Reply to this Message

aaronep@pacbell.net - 08 Sep 2007 16:06 GMT

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

> 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.
[quoted text clipped - 10 lines]
>
> > All replies welcomed! Aaron

Reply to this Message