Hi,Lets come back to Excel series. We have previously talked about text functions in Excel. Before proceeding to detailed description and use of these functions, I would recommend you all to read previous part of this post at Text Functions in Microsoft Excel – Part 1.
Introduction: BAHT is the currency name of Thailand. This function simply convert the number to BAHT text and adds a sign also. But in Thai Text. In simple word, this function converts number to currency in Thai language.
Using Method: This function simply takes a single parameter. A number and writes BAHT amount in words.
=BAHTTEXT(1000) or =BAHTTEXT(A1)
Introduction: CHAR function is derived from word character. As simply name suggests, this function returns the character of your input number based in your computer setting. This takes value from 0-255 and returns all the character set based in your value.
Using Method: This function takes single parameter and that is integer from 0-255.
Example: Suppose ASCII value for 0 (number zero) is 48.
Introduction: CLEAN function simply removes the non-printable character from your supplied string.
Using Method: This function takes single parameter and that is of any kind of value in cell.
=CLEAN(A1) or =CLEAN(CHAR(17)&”This is actual Printable Text.”&CHAR(17))
Introduction: CODE function works just opposite to CHAR function. This returns the character code of your system as input character.
Using Method: This function takes single paramater and of type Character as input.
=CODE(“A”) or =CODE(A1)
Introduction: CONCATENATE function joins multiple text string into one single String. This works with multiple cells.
Using Method: This function can take multiple inputs of different types separated by comma (,).
DOLLAR function converts your number to currency format as per your system locale setting. If you are using United States as your location, then this function will put a dollar sign and comma separator. If you are in India, this will put a Rupees sign as per your system and write as currency. Using Method:
This function takes two parameter, one is value and other is decimal. Then this will convert your number to currency text with decimals as your choice. =DOLLAR(100,2)
or =DOLLAR(A1,2) Example:
Introduction: EXACT function compares two strings and returns Boolean value, True or False. This is case sensitive. If two strings are exactly same, this function returns TRUE and if any of character is different, then FALSE.
Using Method: This function takes two parameters and both in String format from different cells.
=EXACT(A1,B1) or =EXACT(“Google”,”GOOGLE”)
Introduction: FIND function returns the position of search string in another string. This is case sensitive.
Using Method: This function takes minimum of two and maximum of 3 parameters. First one is Find text, this can be simple string value or reference to a cell. Second is the Within text, string where to be searched. Last one is Start number, starting position from where to search. This is optional field.
=FIND(“Help”,A1) or =FIND(A1,B1,2)
Keep reading. I will be writing about remaining function on later posts. Till then keep sharing your knowledge and feedback.