Extract substring in Excel
Function: =MID(B1, FIND("<ns104:Nric",B1) + 51, FIND("</ns104:Nric",B1) - FIND("<ns104:Nric",B1) - 51)
e.g. if B1 = <ns104:Nric xmlns:ns104="http://www.microsoft.com">12345678</ns104:Nric>
Result:12345678
Concatenate String
Function: "1"&B1&"2"
e.g. if B1 = abc
Result: 1abc2
Excel Escape character
Double quote (")
