STARTSWITH

Checks if text starts with prefix.

Origin: A deepcalc original
Excel: No equivalent
Google Sheets: No equivalent
Returns: Text

Examples

=STARTSWITH("hello world", "hello")

Result true

=STARTSWITH(A1, "test")

	A
1	10

Result false

Syntax

STARTSWITH(text, prefix)

text: text required
prefix: text required

Errors

#VALUE!: =STARTSWITH("alpha", A1:A3)

ASCConverts full-width characters to half-width. BAHTTEXTSpells a number as thai baht and satang. CHARReturns the character for a character-set code. CLEANRemoves non-printable characters. CODENumeric code of the first character. CONCATJoins multiple text strings into one.