Hi,
I am currently seeking a solution to extract certain information from XML between tags, name, address, gender etc. Basically I need to be able to make information presentable in a table form. I have used the below formula which works to extract the problem is if i create a template to extract from a certain cell the layout of each different XML changes slightly.
=SUBSTITUTE(SUBSTITUTE(TRIM(CLEAN(A1));"<Name>";"");"</Name>";"")
The above works however I'm not always guaranteed that the information is in cell A1
Is there an excel function to pull a cell containing a specific text? Example search column A for a cell that contains <Name> and present all the data in this cell.Or VBA code that could do this?Any and all input would be greatly appreciated!Thank you
I am currently seeking a solution to extract certain information from XML between tags, name, address, gender etc. Basically I need to be able to make information presentable in a table form. I have used the below formula which works to extract the problem is if i create a template to extract from a certain cell the layout of each different XML changes slightly.
=SUBSTITUTE(SUBSTITUTE(TRIM(CLEAN(A1));"<Name>";"");"</Name>";"")
The above works however I'm not always guaranteed that the information is in cell A1
Is there an excel function to pull a cell containing a specific text? Example search column A for a cell that contains <Name> and present all the data in this cell.Or VBA code that could do this?Any and all input would be greatly appreciated!Thank you
