Need to extract specific XML data from a cell in excel

alvin07 Posts 1 Registration date Tuesday January 7, 2014 Status Member Last seen January 7, 2014 - Jan 7, 2014 at 12:38 PM
 SM - Apr 1, 2019 at 05:59 AM
I have the following data in cell A1 of an excel sheet:


i would like to extract the <StoreId> value from this and print it on the adjacent cell.
i would like 00019 printed on the cell B1.

any help would be much appreciated.


1 response

venkat1926 Posts 1863 Registration date Sunday June 14, 2009 Status Contributor Last seen August 7, 2021 811
Jan 9, 2014 at 12:37 AM
In B1 type the formla


C1 the formula is


in D1 the formula is


D1 will give you what you want,. (00019)

It is possible to combine all the three formula and give one formula
but this is easier to debug.
Thank you so much for this formula. I have been trying to solve an issue for a couple of days now - after a lot of struggle I landed up on this page and your formulas worked great. One request - could you also explain what your formulas are doing on each column - it did not make a lot of sense to me.