Question

what is the use of the right$()and len$()functions​

Answer 1

Explanation:

The len() function returns the number of items in an object. When the object is a string, the len() function returns the number of characters in the string.

To extract the rightmost characters from a string, use the RIGHT function in Excel. To extract a substring (of any length) after the dash, add LEN and FIND. Explanation: the LEN function returns the length of the string. The FIND function finds the position of the dash