Need a Macro to Cut String from the second occurence of a word, and paste into the next ce

[loserianasia]

Dear Experts,

I have a very long text: (law articles) and i would like to put every article in a different cell in excel, using a macro.

The text i have is like below:

Article 1- Hello this is the first article ..................... Article 2- And this is the second article ...................
.............. Article 3- this is the 3rd one.

I copy and paste this whole text into cell "D1".

I would like macro count the word "Article", and starting from the second occurrence of this word, cut rest of the text and paste into the cell below.
Than it'll run the same macro for the cell below and this way every article will be in a different cell; i expect the outcome as follows:

D1 Article 1- Hello this is the first article .....................
D2 Article 2- And this is the second article .................................
D3 Article 3- this is the 3rd one.

Could anybody help with this please?

Thank you

[Andy Pope]

try

Please Login or Register  to view this content.

[loserianasia]

Thanks a lot Andy, this is great.
I wish i had asked this before i manually copied the first 500 articles, but anyway i still have much more to go.

[loserianasia]

Thanks a lot Andy, this is great.
I wish i had asked this before i manually copied the first 500 articles, but anyway i still have much more to go.

[stnkynts]

Try:

Please Login or Register  to view this content.

Edit: Didn't show it as solved to me. My apologies