STARTSWITH
checks if text starts with prefix · a deepcalc original · no excel equivalent · no sheets equivalent
signature
STARTSWITH(text, prefix)
returns: text
| argument | required |
|---|---|
| text | required |
| prefix | required |
examples
formula and result, taken from the engine's own test suite — every result below is asserted in CI, not written by hand.
fx
=STARTSWITH("hello world", "hello") true | A | |
|---|---|
| 1 | 10 |
fx
=STARTSWITH(A1, "test") false errors
error values observed from the engine — each with a call that produces it.
| error | produced by |
|---|---|
| #VALUE! | =STARTSWITH("alpha", A1:A3) |