Text Functions - 'L' to 'P'

LEFT- returns specified number of characters from left
-------------------------------------------------------------------
Ex. =LEFT("welcome",3) returns "wel"
     =LEFT("welcome") returns "w"


LEN  - returns length of string
-------------------------------------------------------------------
Ex. . =LEN("welcome") returns "7"


LOWER - returns string in lowercase
-------------------------------------------------------------------
Ex. . LOWER("HeLlo") returns "hello"


MID -returns string from middle of a string
------------------------------------------------------------------- 
Ex.  =MID("welcome",2,4) returns "elco"
       =MID("welcome",3,1) returns "l"

different tricks with mid function

NUMBERVALUE -returns the number value in locale

-------------------------------------------------------------------
Signature :  NUMBERVALUE(number , decimal_seperator , group_seperator)

Ex. . =NUMBERVALUE("2,550k88" ,  "k" ,  "," ) returns "2500.88"

     =NUMBERVALUE("2,550.88" ,  "." ,  "," ) returns "2500.88"

PROPER  - returns string in Proper case (first letter in Capitals rest in small)
-------------------------------------------------------------------

Ex. . =Proper("welCOMe") returns "Welcome"

check LOWER , UPPER