Loading...
Loading...
Remove non-printable characters from imported or messy text.
| Function | Use Case | Syntax |
|---|---|---|
| LEN | Count the number of characters in a text string. | =LEN(text) |
| Function | Use Case | Syntax |
|---|---|---|
| TEXT | Format numbers, dates, or times as text using custom formatting. | =TEXT(value, format_text) |
| FIND | Locate the position of a character or substring in text. | =FIND(find_text, within_text, [start_num]) |
| SUBSTITUTE | Replace specific text within a string. | =SUBSTITUTE(text, old_text, new_text, [instance_num]) |