TEXTBEFORE, TEXTAFTER and POWER function in Ms Excel

Thiam show tumna a nilo a, show tham pawh ka thiam lo, ka thiam ve chhun te tangkaipui kan lo awm ve takin....
I don't mean it for showing off my thing, I don't even have any special ability to be proud with, but just in case, someone might get a little benefit from my humble production....