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.

None of the spaces here are required. As you can see in the screenshot below, the formula works without these spaces. You can access an Excel workbook and accompanying video below for combining a ...