Excel text formula,
BAHTTEXT
Convert a number to text (baht)
CHAR
Returns the character spcecified by the code number from the character set for your computer.Number is a number between 1 and 255 specifying which character you want.
CLEAN
Remove all nonprintable characters from text.
CONCATENATE
Joins serveral text strings into one text string.
DOLLAR
Converts a number to text,using currency format.
EXACT
Checks whether two text string are exactly the same,and return TRUE or FALSE.EXACT is case-sent
FIND
Retuen the starting position of one text string within another text string.FIND is case-sensitive.
SERACH
Retuen the number of the character at which a specific character or text string is first found,reading left to right(not case-sensitive).
FIXED
Returns the starting position of one text string within another text string.FIND is case-sensitive.
RIGHT
Returns the specified number of characters from the end of a text string.
LEFT
Return the specified number of characters from the strart of a text string.
LEN
Return the number of characters in a text string.
UPPER
Convets a text string to all uppercase letters.
LOWER
Converts all letters in a text string to lowercase.
PROPER
Converts a text string to proper case;the first letter in each word in uppercase and all other letters to lowercase.
LEN
Returns the number of characters in a text string.
MID
Return the characters from the middle of text string,given a starting position and length.
REPLACE
Replaces part of a text string with a different text string.
REPT
Repeats text a given number of times.USe REPT to fill a cell with a number of instances of a text string.
SUBSTITUTE
Replaces existing text with new text in a text string.
TEXT
Converts a value to text in a specific number format.
TRIM
Removes all spaces from a text string except for single spaces between words.
T
Checks whether a value is text,and returns the text if it is,or returns double quotes(empty text)if it is not.
VALUE
Converts a text string that represents a number to a number.
https://instagram.com/computerlearnin...
