USING MICROSOFT EXCEL
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LEFT
|
|
|
LOWER
|
|
|
PROPER
|
|
|
RIGHT
|
Detailed explanation-1: -It converts uppercase letters to lower case for the specified text or expression. Let’s use some examples and view the output of this function.
Detailed explanation-2: -The LOWER() function converts a string to lower-case.
Detailed explanation-3: -The lower() method converts all uppercase characters in a string into lowercase characters and returns it.
Detailed explanation-4: -Use the SQL LOWER() function if you want to convert a string column to lowercase. This function takes only one argument: the column whose values you want to lowercase. This function is a good choice if your database is case sensitive and you want to select only records matching a particular string.
Detailed explanation-5: -LOWER() function in SQL Server This function in SQL Server helps to convert all the letters of the given string to lowercase. If the given string contains characters other than alphabets, then they will remain unchanged by this function. Parameters : str – The string which will be converted to lowercase.