[trunkzzzzz]

hello there... please somebody help me in this problem....

...let's say i have this strings in A1

v1 this is v2 my problem v3 and i want to v4 solve this

...how can i distribute these strings here in different rows, like my suppose output below...

v1 this is
v2 my problem
v3 and i want to
v4 solve this

...is there any way that i can define a formula that whenever the strings reaches the "v2" string, it will automatically separate the first string "v1 this is", and after that it will separate the "v2 my problem" and place to another row?

please help guys...

thanks in advance


...how can i make a formula that only copies strings that i want. i mean, it will stop copying strings whenever it reaches a string that i defined that it should stop there....