Parsing & Conversion functions
All 7 functions in this category
TO_DATETO_DATE converts text or serial numbers into a date value, enabling date calculations and consistent formatting across your spreadsheet.TO_PERCENTConverts decimal values to percentage format, displaying numbers like 0.25 as 25% for easy readability in spreadsheets and reports.TO_DOLLARSConverts a numeric value to a text string formatted as currency with a dollar sign, commas, and two decimal places for display.TO_TEXTConverts a value to text format, returning its content as plain text regardless of the original data type or formatting.TO_PURE_NUMBERConverts a value to its pure numeric form, removing formatting like currency, percentage, or text labels to expose the underlying number.SPLITSPLIT breaks a text string into an array of substrings by dividing on a specified delimiter or by individual characters.JOINConcatenates multiple text values or array elements into a single string, separated by a delimiter you specify.