Uses of Text Function in Ms Excel


Function Description
Find Finds one text value within another (case-sensitive)
Len To get the length or Correcter of a string, use the len function
Left Returns the leftmost characters from a text value
Lower The string that you wish to convert to lowercase.
Mid Returns a specific number of characters from a text string starting at the position you specify
Right Returns the rightmost characters from a text value
Substitute To replace existing text with new text in a string, use the Substitute function.
Trim Removes spaces from text
Upper The string that you wish to convert to uppercase.
Value Converts a text argument to a number

LEN 



Latest
Previous
Next Post »