If cell A1 contains "Jon Doe," it is corrected to "John Doe." Replace "start_number" with "FIND (find_text,source)" without quotes to locate the starting position for the "Replace" function.

Mary Ann Richardson explains that when concatenating date and text cell data in an Excel formula, you need to convert date cells to text to avoid unexpected results.

Learn how to identify formula cells the easy way using VBA, and then combine VBA and conditional formatting for more permanent identification.

Save this for the spreadsheet jocks in your office—we'd bet even the experts don't know all of these formula tips.

Adding a text to a cell in Excel using Formula requires use of ampersand operator, CONCAT function, or the LEFT, RIGHT, and LEN functions.