Excel Tutorial 24 Text Function
1. BAHTTEXT(number) : Converts a number to text (baht)
2. CHAR(number) : Returns the character specified by the code number from the character set for your computer.
3. CLEAN(text) : Remove all nonprintable characters from text.
4. CODE(text) : Returns a numeric code for the first character in a text string, in the character set used by your computer.
5. CONCATENATE(text1,text2,) : Joins several text strings into one text string.
6. DALLAR(number,decimals) : Converts a number to text, using currency format.
7. EXACT(text1,text2,) : Checks whether to text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
8. FIND(find_text,Within_text,start_num) : Returns the starting position of one text string, within another text string. FIND is case-sensitive.
9. FIXED(number,decimals,no_commas) : Rounds a number to the specified number of decimals and returns the result as text with or without commas.
10. LEFT(text,num_chars) : Returns the specified number of characters from the start of a text string.
11. LEN(text) : Returns the number of characters in a text string.
12. LOWER(text) : Converts all letters in a text string to lowercase.
13. MID(text,start_num,num_chars) : Returns the characters from the middle of a text string, given a starting position and length.
14. PROPER(text) : Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase.
15. REPLACE(old_text,start_num,num_chars,new_text) : Replaces part of a text string with a different text string.
16. REPT(text,number_times) : Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
17. RIGHT(text,num_chars) : Returns the specified number of characters of the end of a text string.
18. SEARCH(find_text,within_text,start_num) : Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).
19. SUBSTITUTE(text,old_text,new_text,instance_num) : Replaces existing text with new text in a text string.
20. T(value) : Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not.
21. TEXT(value,format_text) : Converts a value to text in a specific number format.
22. TRIM(all) : Removes all spaces from a text string except for single spaces between words.
23. UPPER(text) : Converts a text string to all uppercase letters.
24. VALUE(text) : Converts a text string that represents a number to number.
Key Search : excel advanced tutorial + excel macro tutorial + vba excel tutorial +
excel functions tutorial + advanced excel tutorial + basic excel tutorial
1. BAHTTEXT(number) : Converts a number to text (baht)
2. CHAR(number) : Returns the character specified by the code number from the character set for your computer.
3. CLEAN(text) : Remove all nonprintable characters from text.
4. CODE(text) : Returns a numeric code for the first character in a text string, in the character set used by your computer.
5. CONCATENATE(text1,text2,) : Joins several text strings into one text string.
6. DALLAR(number,decimals) : Converts a number to text, using currency format.
7. EXACT(text1,text2,) : Checks whether to text strings are exactly the same, and returns TRUE or FALSE. EXACT is case-sensitive.
8. FIND(find_text,Within_text,start_num) : Returns the starting position of one text string, within another text string. FIND is case-sensitive.
9. FIXED(number,decimals,no_commas) : Rounds a number to the specified number of decimals and returns the result as text with or without commas.
10. LEFT(text,num_chars) : Returns the specified number of characters from the start of a text string.
11. LEN(text) : Returns the number of characters in a text string.
12. LOWER(text) : Converts all letters in a text string to lowercase.
13. MID(text,start_num,num_chars) : Returns the characters from the middle of a text string, given a starting position and length.
14. PROPER(text) : Converts a text string to proper case; the first letter in each word in uppercase, and all other letters to lowercase.
15. REPLACE(old_text,start_num,num_chars,new_text) : Replaces part of a text string with a different text string.
16. REPT(text,number_times) : Repeats text a given number of times. Use REPT to fill a cell with a number of instances of a text string.
17. RIGHT(text,num_chars) : Returns the specified number of characters of the end of a text string.
18. SEARCH(find_text,within_text,start_num) : Returns the number of the character at which a specific character or text string is first found, reading left to right (not case-sensitive).
19. SUBSTITUTE(text,old_text,new_text,instance_num) : Replaces existing text with new text in a text string.
20. T(value) : Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not.
21. TEXT(value,format_text) : Converts a value to text in a specific number format.
22. TRIM(all) : Removes all spaces from a text string except for single spaces between words.
23. UPPER(text) : Converts a text string to all uppercase letters.
24. VALUE(text) : Converts a text string that represents a number to number.
Key Search : excel advanced tutorial + excel macro tutorial + vba excel tutorial +
excel functions tutorial + advanced excel tutorial + basic excel tutorial