CLEAN function - Microsoft Support
Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
TRIM function - Microsoft Support
Description. Removes all spaces from text except for single spaces between words. Use TRIM on text that you have received from another application that may have irregular spacing. Important: The TRIM function was designed to trim the 7-bit ASCII space character (value 32) from text.
Top ten ways to clean your data - Microsoft Support
Remove characters from text. Shows how to use the Replace command and several functions to remove text. Find or replace text and numbers on a worksheet. Show how to use the Find and Replace dialog boxes. FIND, FINDB SEARCH, SEARCHB REPLACE, REPLACEB SUBSTITUTE LEFT, LEFTB RIGHT, RIGHTB LEN, LENB MID, MIDB
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.
RIGHT, RIGHTB functions - Microsoft Support
RIGHTB returns the last character or characters in a text string, based on the number of bytes you specify. Important: These functions may not be available in all languages.
Edit cell contents - Microsoft Support
To delete characters, click in the cell where you want to delete them, and then press BACKSPACE, or select the characters and then press DELETE. To replace specific characters, select them and then type the new characters.
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 (~).
CLEAN function - Microsoft Support
Use CLEAN on text imported from other applications that contains characters that may not print with your operating system. For example, you can use CLEAN to remove some low-level computer code that is frequently at the beginning and end of data files and cannot be printed.
TEXTSPLIT function - Microsoft Support
Splits text strings by using column and row delimiters. The TEXTSPLIT function works the same as the Text-to-Columns wizard, but in formula form. It allows you to split across columns or down by rows. It is the inverse of the TEXTJOIN function.
LEFT, LEFTB functions - Microsoft Support
LEFT returns the first character or characters in a text string, based on the number of characters you specify. LEFTB returns the first character or characters in a text string, based on the number of bytes you specify. Important: These …
REPLACE, REPLACEB functions - Microsoft Support
The REPLACE and REPLACEB function syntax has the following arguments: Old_text Required. Text in which you want to replace some characters. Start_num Required. The position of the character in old_text that you want to replace with new_text. Num_chars Required. The number of characters in old_text that you want REPLACE to replace with new_text.