Hi everyone,
I have this information which is big load of code and i need to extract only the part in green which will always be anticipated by <p> and followed by </p>
Anyway i can achieve this? see the attachments!
thank you all!
=MID(A9,SEARCH("<p>",A9)+3,SEARCH("</p>",A9)-SEARCH("<p>",A9)-3)
I thought of using something like this but it does give me some blank space both at the beginning and at the end...
Last edited by vanthetsar; 04-04-2016 at 10:25 AM.
Hi,
One way
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Thanks did these deleted the space!Originally Posted by Richard Buttrey
There are still white space characters such as CHAR(160) left in Richard's formula and the lengths of the extracted string is 172 characters long. However, it should be 159.
Try this formula
Formula:Please Login or Register to view this content.
If you like my answer please click on * Add Reputation
Don't forget to mark threads as "Solved" if your problem has been resolved
"Nothing is so firmly believed as what we least know."
--Michel de Montaigne
There are still white space characters such as CHAR(160) left in Richard's formula and the lengths of the extracted string is 172 characters long. However, it should be 159.
Try this formula
Formula:Please Login or Register to view this content.
This one works perfeclty fine, thanks!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks