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.