Insert page break & merge text in 2 rows

[Guest]

Hello, I'm an absolute beginner and have 2 things I would like to do on a
worksheet:
1. Insert page break when certain text is found
2. Merge text in 2 rows into the upper row, then delete the lower row (i.e.
text part 1 is in row 10 and text part 2 is in row 11, would like to
concatenate the 2 rows and have the text display in row 10, then remove row
11)

Thanks!

 

[Guest]

Hi ka2cil
Click on View / Page Break

Select the two rows Click on Format / Cells then the allignment tab and then
check the Merge Cells check box and click OK

 

[Guest]

Oops, I guess I failed to state that I would like to do this programmatically
b/c I need to loop thru the spreadsheet and repeat the commands depending if
I find a certain words/phrase on the spreadsheet.

Interesting to get a response from a fellow bball fan