LEFT - Returns the First Character(s) of a String

top menu gradient

Back to website

Reference

REFERENCE

Glossary Components Functions

ABS ADD_COLUMN ADD_COLUMN_AFTER ADD_COLUMN_BEFORE ADD_COMPONENT ADD_FIRST_ROW ADD_RECORDS ADD_ROW ADD_ROW_AFTER ADD_ROW_BEFORE ADDRESS AND ANIMATION_STOP APPEND APPEND_RANGE ARRAYFORMULA AUG AVERAGE AVERAGEIF AVERAGEIFS BASE_ADD BASE_DELETE BASE_RENAME BASES BROWSER_TOPLEVEL_URL BROWSER_URL CACHE CACHE_CLEAR CACHE_ENTRIES CACHE_GET CACHE_KEYS CACHE_SET CACHES CAST CEILING CELL CHAR CHOOSE CLEAR_CELL CLEAR_CELL_VALUE COLUMN COLUMN_OF COLUMNS CONCAT_ROWS CONCATENATE CONVERT_DATETIME COPY_COMPONENT COPY_COMPONENTS COPY_STYLE_IF COUNT COUNT_RECORDS COUNT_ROWS COUNTIF COUNTIFS CURRENT_PAGE CURRENT_USER CURRENT_UTC_OFFSET DATE DATETIMEVALUE DATEVALUE DAY DEBOUNCE DECODE_URL DELETE DELETE_CACHE DELETE_COLUMN DELETE_COLUMNS DELETE_EXT DELETE_MAIN_COLUMNS DELETE_MAIN_ROWS DELETE_RECORDS DELETE_RECORDS_BY_ID DELETE_ROW DELETE_ROW_AT DELETE_ROWS DND_APPEND DND_COPY DND_MOVE DND_SWAP DO DO_AFTER DO_EVERY DO_IF_CHANGED DO_PARALLEL DOWNLOAD_AS_CSV DOWNLOAD_AS_EXCEL E E_ITEM_INDEX EMOJI EMOJI_SEARCH EMOJIS ENCODE_URL ENV EOMONTH EXCLUDE_COLUMNS EXTRACT EXTRACT_COLUMNS EXTRACT_TO FILE FILES FILTER FILTER_IN_SET FIND FIND_REPLACE FLIP_FRAME FLOOR FORMAT_DATE FORMAT_NUMBER FORMULAEVAL FORMULATEXT FRAME FROM_BASE64 FROM_EMOJI FROM_JSON FROM_TIMESTAMP GET GET_3RD_PARTY_LOGIN_INFO GET_CELL GET_COOKIE GET_EXT GET_QUERY_PARAMS GET_RECORDS GOTO_PAGE GRAB GRAB_LIST GROUP_BY GUID HAS_COLUMN HAS_COLUMNS HAS_COOKIE HASH_HMAC_SHA1 HIDE_ALL_OVERLAYS HIDE_OVERLAY HIDE_TOPMOST_OVERLAY HLOOKUP HOUR IF IFERROR INDEX IS_EMOJI IS_ERROR IS_LOADING IS_LOGGED_IN_3RD_PARTY IS_NULL IS_STREAMING ISBLANK JOIN JOIN_FRAMES JOIN_FRAMES_CROSS_PRODUCT JOIN_FRAMES_FULL JOIN_FRAMES_LEFT JOIN_FRAMES_RIGHT JSON JSON_PRETTY LAST_BY LEFT LEN LOGIN_WITH_3RD_PARTY LOGOUT LOGOUT_3RD_PARTY LOWER MATCH MAX MID MIN MINUTE MOD MONTH NOT NOW OAUTH_SIGN OR PARSE_TIMESTAMP PATCH PATCH_EXT PATH POST POST_EXT POST_FORM POWER PRINT_CELLS PRINT_RANGES PUT PUT_EXT RANDBETWEEN RANDOM RANGE RANGE_VALUES REGEXEXTRACT REGEXMATCH REGEXREPLACE REMOVE_ALL_COMPONENTS REMOVE_COMPONENT REMOVE_COMPONENTS_OF REPLACE RESTART RIGHT ROUND ROW ROW_AT ROWS_AT SAMPLE SAMPLE_PERCENT SAVE_FILE SAVE_FILES SECOND SEND_TO_PARENT SERIES SET_BINDING SET_CELL SET_CELL_VALUE SET_COOKIE SET_FRAME_CELL SET_RANGE_BINDING SHOW_OVERLAY SORT SPLIT START STOP SUBMIT_FORM SUBSTITUTE SUM SUMIF SUMIFS TABLE_ADD_ROWS TABLE_COLUMNS TABLE_DELETE TABLE_DELETE_COLUMNS TABLE_DELETE_COLUMNS_EXCEPT TABLE_DELETE_ROWS TABLE_DELETE_ROWS_BY_ID TABLE_RENAME TABLE_ROW_COUNT TABLE_ROWS TABLE_SET_COLUMN_ORDER TABLE_SPEC TABLE_UPDATE_ROWS TABLE_UPDATE_ROWS_BY_ID TABLE_UPSERT_ROWS TABLES TEXT_TEMPLATE TEXTJOIN TIME TIMESTAMP TIMEVALUE TO_BASE64 TO_EMOJI TO_UTC_AT_OFFSET TODAY TOGGLE TOGGLE_OVERLAY TRANSPOSE TRIM TWEEN TYPE_OF UPDATE_COLUMN UPDATE_FIRST_ROW UPDATE_LAST_ROW UPDATE_RECORDS UPDATE_RECORDS_BY_ID UPDATE_ROW UPLOAD_FILE UPPER UPSERT_RECORDS UPSERT_ROW URL VIEWPORT VLOOKUP WEEKDAY WRAP YEAR

Blocks Data Types

Previous – FunctionsLAST_BY Next – FunctionsLEN

Contents