Excel Functions / TEXT / CHAR

In Short: This function returns the ANSI (American National Standard Institute) code of the number provided.

Explained:
Every character used by our computer, in general, and Microsoft Excel, in particular, has a specific number assigned to it. Microsoft makes use of ANSI codes that are set by an American private non-profit organization (ANSI Website). Out of these from 32 to 126 are taken from ASCII set.

Below is a screen shot where we have entered four examples to replicate the working of "CHAR" function.

Moreover, for complete list of ANSI function supported please visit Microsoft Developer network Here

Excel Functions / TEXT / BAHTTEXT

In Short: This function converts any digit or number written in numerical into words in Thai language.

Explained:

Let us suppose we enter 156 as number in cell A1 and formula "BAHTTEXT(A1)" in adjacent cell B1.

It will give result as One hundred and fifty six baht Only.

Moreover I have also attached the screenshot for the translation. Although most of the online translators were not giving results correctly. But I have tried to gather as far as possible.