Excel Functions / TEXT / CONCATENATE

In Short: This function is used to join two or more text strings into one text string.

Explained: 
This function is used to join two or more (maximum up-to 255) text strings.

But apart from using this function, we can also use the ampersand operator to join strings.

For joining text strings from any other cell, we should directly enter cell reference, but if we need to write something to join, it should be done under double quotes ("").

To insert space in between, we can join by entering " ", i.e. space between double quotes.

The following example further depicts the same.

Add caption

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.

Ma Fst Post.............

This blog is for both excel lovers and excel learners (that includes me also).

Although I am not a excel expert but you can know me as excel freak...I will experience my learning and knowledge of excel that can help all excel learners to begin with.

Also this blog will definitely help we all to share our knowledge and increase our knowledge base of excel and yes definitely VBA for Excel......