Merging Text Rows into single Row - separated by row of quaracters or blank

[designooze]

Hi everyone,

Really need help with the following:
I'm trying to merge rows of text into a single row, and repeat for every paragraph. Each paragraph/quote is seperated by a row of ******** / although I could just make that a blank row.

The number of rows that need to be merged into a single row aren't necessarily equal in number. I've attached a screen print for you to have an idea.

ScreenHunter_57 Jun. 08 20.04.jpg

Any way this can be done? (or in Word?)

Thanks!

[mrice]

Try this macro assuming all the data is in column A and you have a blank row between each group

Please Login or Register  to view this content.

Open up the VBA editor by hitting ALT F11

Insert a new module by hitting Insert - Module

Paste the macro into the empty sheet

Hit ALT F11 to get back to the worksheet.

Run the macro by going to tools-macro in Excel 2003 or the view ribbon in Excel 2007/2010.