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.