Learning level
70/100
Product version
1.0.1
Guide status
Stable
Sections
3
Text Functions
Implementation-backedClean, extract, find and combine text with VauSheet's implemented text functions.
What this guide covers
Inspect and clean
Extract and find
Replace and combine
Quick facts
Version1.0.1
SurfaceWeb browser
StorageCloud + local checkpoint
ThemeLight · white/orange
Documentation rule: this VauSheet section describes the current implemented product behavior. It avoids claiming full Microsoft Excel parity or live-cursor collaboration where the current build does not provide it.
01
Inspect and clean
LEN counts characters and TRIM removes outer whitespace while collapsing repeated whitespace.
02
Extract and find
LEFT, RIGHT and MID return substrings. FIND returns a 1-based position and reports an error if the search text is not found.
03
Replace and combine
SUBSTITUTE replaces text, TEXTJOIN joins multiple values with a delimiter, CONCAT concatenates values, and LOWER/UPPER change case.
Updated 2 Sep 2026VauSheet 1.0.1