Perhaps someone here can point me in the right direction. I've just started trying to write macros in Excel and, umm, have a lot to learn.
I want to create a macro that merges any cell beginning with specific text with the cell directly above. As an example, I have a large Excel spreadsheet that looks similar to this:
1 This is a
2 xxxxsample
3 xxxxsentence.
4 This is also
5 xxxxa sample sentence.
6 This is
7 xxxxalso a
8 xxxxsample sentence.
and so on for several thousand rows, all in one column.
I want the cells beginning with "xxxx" to be merged (concatenated?) with the cell directly above, so that, if this were done for the entire worksheet, each sentence would all be in one cell, as opposed to spread out over multiple rows.
Does this make sense? Is it doable? Any suggestions?
Thanks for any help!
I want to create a macro that merges any cell beginning with specific text with the cell directly above. As an example, I have a large Excel spreadsheet that looks similar to this:
1 This is a
2 xxxxsample
3 xxxxsentence.
4 This is also
5 xxxxa sample sentence.
6 This is
7 xxxxalso a
8 xxxxsample sentence.
and so on for several thousand rows, all in one column.
I want the cells beginning with "xxxx" to be merged (concatenated?) with the cell directly above, so that, if this were done for the entire worksheet, each sentence would all be in one cell, as opposed to spread out over multiple rows.
Does this make sense? Is it doable? Any suggestions?
Thanks for any help!