Insert ASCII or Unicode Latin-based symbols and characters
If you only have to enter a few special characters or symbols, you can use the Character Map or type keyboard shortcuts. See the tables below, or see Keyboard shortcuts for international characters for a list of ASCII characters.
Check if a cell contains text (case-insensitive) - Microsoft Support
Find cells that contain text. Follow these steps to locate cells containing specific text: Select the range of cells that you want to search. To search the entire worksheet, click any cell. On the Home tab, in the Editing group, click Find & Select, and then click Find.
Format text or numbers as superscript or subscript
Select characters in a cell or cell range that you’d like to format. On the Home tab, in the Font group, select the Font Settings dialog box launcher. OR. Press CTRL+1. Under Effects, check the Superscript or Subscript box, and click OK.
Insert a symbol - Microsoft Support
Insert a checkmark, musical note, or other characters by using a symbol from a table or keyboard shortcut.
Using wildcard characters in searches - Microsoft Support
Use wildcard characters as comparison criteria for text filters, and when you're searching and replacing content. This feature enables you to find values that share a simple pattern. These characters can be the asterisk (*), the question mark (?), and the tilde (~).
Find or replace text and numbers on a worksheet
Use the Find and Replace features in Excel to search for something in your workbook, such as a particular number or text string. You can either locate the search item for reference, or you can replace it with something else. You can include wildcard characters such as question marks, tildes, and asterisks, or numbers in your search terms.
TEXTAFTER function - Microsoft Support
When searching with an empty delimiter value, TEXTAFTER matches immediately. It returns the entire text when searching from the front (if instance_num is positive) and empty text when searching from the end (if instance_num is negative). Example.
Hide or display cell values - Microsoft Support
In the Category box, click General to apply the default number format, or click the date, time, or number format that you want. Tip: To cancel a selection of cells, click any cell on the worksheet. By applying a custom number format, you can hide the values of certain cells on the worksheet.
Text functions (reference) - Microsoft Support
Changes half-width (single-byte) English letters or katakana within a character string to full-width (double-byte) characters. DOLLAR function. Converts a number to text, using the $ (dollar) currency format. EXACT function. Checks to see if two text values are …
Count characters in cells - Microsoft Support
Count characters in cells by using the LEN function. This topic explains how to count one or more cells and use LEN in an array formula.
SUBSTITUTE function - Microsoft Support
SUBSTITUTE (text, old_text, new_text, [instance_num]) The SUBSTITUTE function syntax has the following arguments: Text Required. The text or the reference to a cell containing text for which you want to substitute characters. Old_text Required. The text you want to replace.