Hi
I will periodically be pasting the contents of a web page in cell A1 (the paste execution will actually spread the info from A1 down to about A100) The web page always has specific headers which usually paste to the same lines but not always.
So in cell B1 I need a formula to look at the range A1 to A100, and return the text that Begins with, say, the word "Introduction"
Then in B2 and B3. I need the formulae to return the text from the first and second rows (respectively) under the cell that began with the word "Introduction".
(There are several other headers that I will be extracting also, but I can apply the same principle once I've learned how to do it.)
For Example
Imagine I paste from the site and there's a line that reads: "Introduction: Why we must always pay attention" That string has pasted onto A8 this time. In A9 there appears the text "Because it shows respect", and in A10: "You will get better grades if you do".
B1 looks through A1:A100 for the line that begins "Introduction" (there will always be a string that begins this way) and locates it in A8 and returns "Introduction: Why we must always pay attention"
B2 needs to return "Because it shows respect"
B3 needs to return "You will get better grades if you do"
As the latter two strings will be different each time, I cannot search for a string but must return an offset result 1 and 2 cells below the cell that began with "Introduction"
Thanks
Damo
I will periodically be pasting the contents of a web page in cell A1 (the paste execution will actually spread the info from A1 down to about A100) The web page always has specific headers which usually paste to the same lines but not always.
So in cell B1 I need a formula to look at the range A1 to A100, and return the text that Begins with, say, the word "Introduction"
Then in B2 and B3. I need the formulae to return the text from the first and second rows (respectively) under the cell that began with the word "Introduction".
(There are several other headers that I will be extracting also, but I can apply the same principle once I've learned how to do it.)
For Example
Imagine I paste from the site and there's a line that reads: "Introduction: Why we must always pay attention" That string has pasted onto A8 this time. In A9 there appears the text "Because it shows respect", and in A10: "You will get better grades if you do".
B1 looks through A1:A100 for the line that begins "Introduction" (there will always be a string that begins this way) and locates it in A8 and returns "Introduction: Why we must always pay attention"
B2 needs to return "Because it shows respect"
B3 needs to return "You will get better grades if you do"
As the latter two strings will be different each time, I cannot search for a string but must return an offset result 1 and 2 cells below the cell that began with "Introduction"
Thanks
Damo
Last edited:
