Find and Replace is a useful feature in the Office suite programs which allows replacing an existing text with a new text. However, it can also be used to find and replace the color of the text. You ...
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.