USING MICROSOFT EXCEL
USING THE RIGHT LEFT AND MID FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
LEFT and MID
|
|
|
RIGHT and LEN
|
|
|
MID and LEN
|
|
|
LEFT and LEN
|
Detailed explanation-1: -The LPAD() function left-pads a string with another string, to a certain length. Note: Also look at the RPAD() function.
Detailed explanation-2: -LPAD is used to pad the left side of a base string with a given pad string. It will repeat the pad string until the given length is met. RPAD is similar but adds the padding on the right side of the base string. This can be useful anywhere a certain pad is required, such as requiring leading 0’s or leading spaces.
Detailed explanation-3: -Some RDBMSs provide an LPAD() and RPAD() function that enables us to left pad or right pad a string. Some functions also allow us to add leading or trailing zeros numbers. Below are examples of applying SQL padding in some of the more popular RDBMSs.