Insert page break & merge text in 2 rows
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!
|