Excel MID Function (5 Practical Examples)
Excel MID Function The excel MID Function is used to return a specific number of characters from a text string, starting at the position users specify, based on the number of characters they specify. For example, =MID(“amazon”, 2,2) returns “ma”. In this section: Advertisements Syntax of MID Function Extract First Name from Full Name Extract […]
Excel LOWER Function (4 Practical Examples)
Excel LOWER Function Excel LOWER Function converts upper case letters in a text string to lowercase. The LOWER Function has only one argument, Text, which can be a text or reference to cell with the text string. LOWER function does not affect numbers, punctuations, and all spaces. In this section: Advertisements Syntax of LOWER Function […]
Excel LEN Function (5 Practical Examples)
Excel LEN Function The excel LEN function is a text function, and it returns the number of characters in a text string. The number of characters in a text string is used to find values. The LEN function can also be used to find the the hidden trailing space. In this section: Advertisements Syntax of […]
Excel LEFT Function (6 Practical Examples)
Excel LEFT Function The excel LEFT Function returns the first character or characters in a text string based on the number of characters users specify. On the other hand, LEFTB returns the first character or characters in a text string, based on the number of bytes users specify. The Excel LEFT function is used to extract […]
Excel FIXED Function ( 5 Practical Examples)
Excel FIXED Function The excel FIXED Function rounds a given number to the specified number of decimals, formats the number in decimal format using a period and commas, and returns the result as text. In this section: Advertisements Syntax of FIXED Function FIXED rounds to 2 decimal places Round the numbers without COMMA -1 and […]
Excel FIND Function (6 Practical Examples)
Excel FIND Function Excel FIND Function is used to find one text string within another text string, and it returns the number of the string position of the first text string based on the first occurrence of the text string in the second string. This FIND function is case sensitive. FIND function can be used […]
Excel EXACT Function (5 Practical Examples)
Excel EXACT Function The excel EXACT function is a text function and it test whether two or more supplied text strings are exactly same. If the text strings are exactly the same, the excel EXACT Function returns “TRUE“. The EXACT Function is case sensitive. In this section: Advertisements Syntax of EXACT Function Compare two text […]
Excel BAHTTEXT Function (1 Unique example)
Excel BAHTTEXT Function The excel BAHTTEXT function converts a number to Thai text and adds a suffix of “Baht.” Users can change the Baht format to a different style in the Excel desktop application by using Regional and Language Options (Windows Start menu, Control Panel). In this section: Advertisements Syntax of BAHTTEXT Function Example of how Excel BAHTTEXT works. 1. […]
Excel DBCS Function (2 Unique examples)
Excel DBCS Function The excel DBCS function is a text function and it is used to convert single byte characters into double byte characters in a text string. Users use this function in a multiple language environment. DBCS function converts half-width characters into full-width characters. In this section: Advertisements Syntax if DBCS function Example of […]
Excel TRUE Function (4 Powerful examples)
Excel TRUE Function The excel TRUE function returns the value TRUE. The TRUE function is equivalent to Boolean value TRUE. In analysis, TRUE function is used in combination with IF, IFERROR. The TRUE function is associated with FALSE function. In this section: Advertisements Syntax of TRUE function Comparing value if TRUE ISODD with TRUE function […]