TRIMSTART
Removes instances of space character from the beginning of a string.
Syntax:
TRIMSTART(text)
Example:
If text contains " Hello":
TRIMSTART(" Hello")
returns "Hello"
Text:
Result:
Hello
Application:
Removing the leading spaces from Product IDs
Product ID (Original) | Product ID (Clean) | ||
|---|---|---|---|
A | B | ||
1 | 12345 | 12345 | |
2 | 67890 | 67890 | |
3 | 543210 | 543210 | |
4 | 01122 | 01122 | |
5 | 998877 | 998877 |
How TRIMSTART is Used for Product ID (Clean)
For B1: " 12345" becomes "12345" when using TRIMSTART(A1)
For B2: " 67890" becomes "67890" when using TRIMSTART(A2)
For B3: " 543210" becomes "543210" when using TRIMSTART(A3)
For B4: " 01122" becomes "01122" when using TRIMSTART(A4)
For B5: " 998877" becomes "998877" when using TRIMSTART(A5)
PRODUCT & FEATURES
RESOURCES
Terms | Privacy | Spam Policy
© 2026 Zapof