Adding text after a specific number of characters in Excel is a possibility if you know what to do. In this situation, we will be using the LEFT, RIGHT, and LEN functions instead of CONCAT.

Excel's "Find and Replace" feature will search an entire spreadsheet or selected cells for your specified text. Excel also offer a "Replace" function.

Excel has over 475 formulas in its Functions Library, but we've selected the most popular, from date and time functions to mathematics and simple data manipulation.