How to Use the IF Function in Excel to See Who Has Paid. Excel's IF function validates a cell's contents, determining whether it meets criteria that you set. It provides no information beyond what ...

Learn about 10 Text functions in Excel with examples, including Find, Len, Left, Right, Mid, Substitute, Upper, Trim, Concatenate, and Text.

For instance, to cause Excel to highlight any cell that contains the word "profit," press "Ctrl-A" to select all cells and follow the steps described to navigate to the "Format Cells" text box.