Formulas and Functions
ఈ కంట్రో‌ల్‌ను మారిస్తే, ఈ పేజీ ఆటోమేటిక్‌గా అప్‌డేట్ చేయబడుతుంది

CLEAN

The CLEAN function removes most common non-printing characters (Unicode character codes 0–31) from text.

CLEAN(text)

text: Any value from which you want to remove non-printing characters.

Notes

  • This function can be helpful if text you paste from another application contains unwanted question marks, spaces, boxes or other unexpected characters.

  • There are some less common non-printing characters that are not removed by CLEAN (character codes 127, 129, 141, 143, 144 and 157). To remove these, you can use the SUBSTITUTE function to replace them with a code in the range 0–31 before you use the CLEAN function.

  • You can use the TRIM function to remove extra spaces in text.

Example

Suppose you copy what you believe to be the text "a b c d e f" from another application and paste it into cell A1, but instead see "a b c ? ?d e f".  You can try using CLEAN to remove the unexpected characters:

=CLEAN(A1) returns "a b c d e f".

See alsoSUBSTITUTETRIM
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
ఉపయోగకరంగా ఉందా?
అక్షరాల పరిమితి: 250
అక్షరాల గరిష్ట పరిమితి 250.
మీ ఫీడ్‌బ్యాక్ అందించినందుకు ధన్యవాదాలు.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.