LinkBack URL
About LinkBacks
Dear all,
I want to retrieve particular text string in between >X</ by excel formula.
Some example below, Cell A having some data in in between > X </ , from here I want to get data like Cell B ( "X" data required)
CELL A CELL B <mtu>1500</mtu> 1500
Dear all,
I want to retrieve particular text string in between >X</ by excel formula.
Some example below, Cell A having some data in in between > X </ , from here I want to get data like Cell B ( "X" data required)
CELL A CELL B <mtu>1500</mtu> 1500
Try this:
=MID(A1,FIND(">",A1)+1,FIND("<",A1,2)-FIND(">",A1)-1)
Try
=MID(A2,FIND(">",A2)+1,FIND("</",A2)-FIND(">",A2)-1)
Hi 63falcondude & JohnTopley , Yes both formula works perfectly , thanks for helping me.
Glad we could help. Thanks for the rep!
Hi 63falcondude & JohnTopley , I need one more help actually I forgot to mention that in my post , there will be one more Cell “C”. in the cell “C” I want to get “ mtu “ , this mtu will be in between </mtu>
CELL A CELL B CELL C <mtu>1500</mtu> 1500 mtu
Last edited by nur2544; 03-26-2018 at 12:58 PM.
Here's one way:
=SUBSTITUTE(MID(A1,FIND("/",A1)+1,LEN(A1)),">","")
Hi 63falcondude , Yes! it works perfectly, it will help me a lot, I really appreciated it. Thanks for your valuable time in this regard.
Happy to help. Thanks again for the reps!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks