Excel Macro Question 1

[mtpisgah]

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!

 

[SkipVought]

Hi,

Please post macro questions in VBA Visual Basic for Applications (Microsoft) forum707.

Skip,

_[red][/red]

 

[AnotherHiggins]

Please post your VBA/Macro specific question in forum707, the VBA Visual Basic for Applications (Microsoft) Forum.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ181-2886 before posting.

 

[SkipVought]

This can be solved without code...

If you data begins in COLUMN A, ROW 2, then in B2 and copy down...
[tt]
=IF(LEFT(A2,4)="xxxx",B1&" "&RIGHT(A2,LEN(A2)-4),A2)
[/tt]
in column c this formula
[tt]
=IF(AND(LEFT(A2,4)="xxxx",LEFT(A3,4)<>"xxxx"),1,0)
[/tt]
Then FILTER on column C = 1

VOLA!

Skip,

_[red][/red]