The PLAINTEXT function returns a string value stripped of any rich text attributes in the input value.
PLAINTEXT(source-string)
source-string: Any value.
Note
This function isn’t available in iBooks Author.
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”. |