PLAINTEXT

The PLAINTEXT function returns a string value stripped of any rich text attributes in the input value.

PLAINTEXT(source-string)

source-string: Any value.

Examples

If cell A1 contains "lorem ipsum", =PLAINTEXT(A1) returns "lorem ipsum".

If cell B1 contains "lorem ipsum", =PLAINTEXT(B1) returns "lorem ipsum".

=PLAINTEXT(HYPERLINK("www.apple.com", "Apple")) returns "Apple".

=PLAINTEXT(42) returns "42".

See alsoCLEANT
Morty Proxy This is a proxified and sanitized view of the page, visit original site.
Kasulik?
Tähemärkide piirang: 250
Maksimaalne tähemärkide piirang on 250.
Täname tagasiside eest.
Morty Proxy This is a proxified and sanitized view of the page, visit original site.