The FIND function allows you to find a text string within another. It returns the position at which a character or string begins within another text string. The LEN function calculates the length of ...

Use the RANDARRAY() dynamic array function to return random names or other text in Microsoft Excel. The recent article How to generate random letters in Excel shows you how to generate random letters.

In Microsoft Excel, there are a variety of categories of functions such as Math and Trigonometry, Statistical, Financial, Logical, Text, and more. A Text function changes how a number appears by ...

Don't listen to anyone who tells you that the VALUE function in Microsoft Excel is obsolete. You'll probably seldom need to use it on its own, but when combined with other functions, it's still as ...