Excel functions

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 (")