The syntax for the CLEAN function is: = CLEAN ( Text ) Text - (required) the data to be cleaned of non-printable characters. A cell reference to the location of this data in the worksheet. For example, to clean the data in cell A2 in the image above, enter the formula: =CLEAN(A2) into another worksheet cell. DBAs complains that there is Ctrl-M character in the file. Unix and Windows use different line termination characters. Unix use only line feed while windows use both carriage return and line feed as termination characters. This CR and LF become Ctrl-M in Unix. Avoid Ctrl-M character Text editor option.
Type emoji and other symbols
- Click the place in your document or message where you want the character to appear.
- Press Control–Command–Space bar. The Character Viewer pop-up window appears:
- Use the search field at the top of the window, click a category at the bottom of the window, or click in the upper-right corner to expand the window and reveal more characters.
- When you find the character that you want, click or double-click it to insert it in to your text.
In the Messages and Mail apps, you can also see the Character Viewer popup when you click .
Type accented characters
Press and hold a key until its alternate characters appear, then click or type the number under the character that you want to use.
If no additional characters are available for the key that you're holding, the accent menu doesn't appear.
![App App](/uploads/1/2/5/8/125855429/241277004.png)
If you decide that you don't want to type an accented character after holding a key, press the Esc (escape) key.
Repeat a character
Some keys repeat when you press and hold them, depending on where you type them. Press and hold the Space bar or symbol keys (like hyphen or equals) to make these characters repeat in most apps. In apps where accented characters aren't used (like Calculator, Grapher, or Terminal), letter and number keys also repeat when you press and hold them.
If a character isn't repeating, check your Key Repeat settings:
- Choose Apple () menu > System Preferences.
- Click Keyboard.
- Make sure that the Key Repeat slider isn't set to Off.
If a key isn't designed to repeat in the app you’re using, follow these steps:
![Find non ascii characters in text file notepad app for iphone 6 Find non ascii characters in text file notepad app for iphone 6](/uploads/1/2/5/8/125855429/704792645.png)
- Select the character that you want to copy.
- Press Command-C to copy the character to the clipboard.
- Hold Command-V to paste the character repeatedly.