How to Insert a Caret in Excel. Excel, a spreadsheet program in the Microsoft Office suite, allows for the entry of special Unicode characters, such as the caret, tilde, pound sign or asterisk.

Insert Line Break in Excel To move to a new line in an Excel cell, simply type text in the cell as normal and then press enter while holding down the alt key.

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