I need a formula that does substitute ALL "" with "" (including the > character)
<*span style..** .><*div style=...* *>
<*p style..** .>
<**div* *>
<*/div* >
(I added asteriks and spaces otherwise the tags cannot appear :P
Find and replace works for the last 2 but not the others at what occupies the ... is variable font and size information.
The tags may appear more than once in the cell then later on and there are many instances of > before the start text because im dealing with html text
I have this formula that says search A for the text in B and copy the text that's after B until the next ">"
=IFERROR(MID($A3,SEARCH(B$2,$A3)+LEN(B$2),SEARCH(">",$A3,SEARCH(B$2,$A3)+LEN(B$2))-LEN(B$2)-SEARCH(I$2,$A3)),FALSE)
Essentially I want to do the opposite? Instead of copy I want to substitute with ""-removing it- every instance of the start string.
I'm assuming for each tag search it'll just be a separate substitute formula Thank you
<*span style..** .><*div style=...* *>
<*p style..** .>
<**div* *>
<*/div* >
(I added asteriks and spaces otherwise the tags cannot appear :P
Find and replace works for the last 2 but not the others at what occupies the ... is variable font and size information.
The tags may appear more than once in the cell then later on and there are many instances of > before the start text because im dealing with html text
I have this formula that says search A for the text in B and copy the text that's after B until the next ">"
=IFERROR(MID($A3,SEARCH(B$2,$A3)+LEN(B$2),SEARCH(">",$A3,SEARCH(B$2,$A3)+LEN(B$2))-LEN(B$2)-SEARCH(I$2,$A3)),FALSE)
Essentially I want to do the opposite? Instead of copy I want to substitute with ""-removing it- every instance of the start string.
I'm assuming for each tag search it'll just be a separate substitute formula Thank you
Last edited:
