Now, if we add more values to column A, Excel will automatically extend the LEN function downwards. Excel also lets you be more targeted with your use of TRIMRANGE by using Trim References.

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