Use LEN function to provide data for RIGHT function
FORMULAS Use LEN function to provide data for RIGHT function If text strings you have in your range of data are not quite standardized and you need to modify them…
Combine functions to insert a character inside a text string
FORMULAS Combine functions to insert a character inside a text string Using nested functions (combine functions) in Excel formula is very powerful technique which can save you hours of your…