I had a question form one of my colleagues about this. They have a validation list of products which has been used using for some time, with no new products being added. Then today- they are...

The Right function on Excel let's you extract a the last characters, or character in a text string based and it's based on the number of characters you specify you want to extract. This a a really...

Performing calculations is one of the main uses of spreadsheets and Excel allows you to build quite complex formulae using arithmetic operators, but it also has a myriad of predefined functions for...