Question

What is right and left command?

Answer 1

Answer:

For excel -

Right function-

The Excel RIGHT function extracts a given number of characters from the right side of a supplied text string. For example, RIGHT("apple",3) returns "ple". text - The text from which to extract characters on the right. num_chars - [optional] The number of characters to extract, starting on the right.

Left function

The Microsoft Excel LEFT function allows you to extract a substring from a string, starting from the left-most character. The LEFT function is a built-in function in Excel that is categorized as a String/Text Function.