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.