EXCEL FUNCTION – LOWER
LOWER function is used for changing the format of any text or string to LOWER case.
EXCEL FUNCTION – UPPER
UPPER function is used for changing the text/string to UPPER case in Microsoft Excel. The output of the function returns value in new cell.
EXCEL FUNCTION – LEN
LEN function is used for counting number of characters in available string. The output of the function returns the count in new cell.
EXCEL FUNCTION – RIGHT
RIGHT function is used for extracting the “Right Most” characters from the available string in Microsoft excel. Function returns value to new string.
EXCEL FUNCTION – LEFT
LEFT function is used for extracting the “Left Most” characters from the available string. The output of the function returns the extracted characters in new cell