Excel Automation & Custom Solutions
117+ Professional Functions
Purpose-built formulas that work just like Excel's built-in functions
exl_AI_Classify
AI Functions
Classify text into one of the provided categories using AI. Requires Anthropic API key.
Text (string), Categories (string)
=exl_AI_Classify(A1, A1)
exl_AI_Extract
AI Functions
Extract specific data from unstructured text using AI (e.g., company name, dollar amount, date). Requires Anthropic API key.
Text (string), What_To_Extract (string)
=exl_AI_Extract(A1, A1)
exl_AI_FormulaExplain
AI Functions
Explain what an Excel formula does in plain English. Requires Anthropic API key.
Formula (string)
=exl_AI_FormulaExplain(A1)
exl_AI_FormulaWrite
AI Functions
Generate an Excel formula from a plain English description. Requires Anthropic API key.
Description (string)
=exl_AI_FormulaWrite(A1)
exl_AI_Match
AI Functions
Find the best fuzzy match for a value in a range using AI (e.g., "IBM Corp" matches "International Business Machines"). Requires Anthropic API key.
Lookup_Value (string), Lookup_Range (object)
=exl_AI_Match(A1, A1)
exl_AI_Summarize
AI Functions
Summarize text or a range of text values into a concise summary using AI. Requires Anthropic API key.
Text_Or_Range (object), Max_Words (object)
=exl_AI_Summarize(A1, A1)
exl_AI_Translate
AI Functions
Translate text to a target language using AI. Requires Anthropic API key.
Text (string), Target_Language (string)
=exl_AI_Translate(A1, A1)
exl_Barcode
Barcode Operations
Calculate, validate, or format barcodes ("UPC-A", "EAN-13", "EAN-8", "I2of5")
Number (string), Type (object) [optional], Return_Type (object) [optional], Return_Formatted (object) [optional]
=exl_Barcode(A1, A1, A1, ...)
exl_Cartons_Fulfillment
Carton & Shipping
Order fulfillment calculator: given units ordered and units per case pack, figures out the full cartons to ship, any partial quantity, and the variance vs. the order. Returns a 6-column analysis array by default, or a single value via Return_Type. Toggle whether partial cartons are allowed (loose units) and whether overshipping is allowed (round up to fill a carton).
Units_Ordered (double), Case_Pack (double), Allow_Partial (bool), Allow_Overship (bool), Return_Type (object)
=exl_Cartons_Fulfillment(100, 100, TRUE, ...)
exl_Cartons_Pallets_Needed
Carton & Shipping
Calculate number of pallets needed for total cartons (rounds up)
Total_Cartons (double), Cartons_Per_Pallet (double)
=exl_Cartons_Pallets_Needed(100, 100)
exl_Cartons_Qty_Per_Pallet
Carton & Shipping
Calculate cartons per pallet based on dimensions and height limit
Pallet_Length (double), Pallet_Width (double), Carton_Length (double), Carton_Width (double), Carton_Height (double), Max_Stack_Height (double)
=exl_Cartons_Qty_Per_Pallet(100, 100, 100, ...)
exl_Cartons_Volume
Carton & Shipping
Volume calculations. Return_Type: "CubicFeet" (inches input), "CubicMeters" (cm input)
Length (double), Width (double), Height (double), Return_Type (object) [optional]
=exl_Cartons_Volume(100, 100, 100, ...)
exl_Cartons_Weight_Chargeable
Carton & Shipping
Calculate chargeable weight: the greater of actual weight or dimensional weight. Carriers bill based on whichever is higher.
Actual_Weight (double), Dimensional_Weight (double)
=exl_Cartons_Weight_Chargeable(100, 100)
exl_Cartons_Weight_Dimensional
Carton & Shipping
Calculate dimensional (volumetric) weight: (Length × Width × Height) / Divisor. Divisor defaults to 166 (domestic); use 139 for international or 194 for USPS.
Length (double), Width (double), Height (double), Divisor (object) [optional]
=exl_Cartons_Weight_Dimensional(100, 100, 100, ...)
exl_Currency_Convert
Currency
Convert currency using manual exchange rate: Amount × Rate
Amount (double), Exchange_Rate (double), Round_To (object) [optional]
=exl_Currency_Convert(100, 100, A1)
exl_Currency_Convert_Live
Currency
Convert currency using live exchange rates (requires internet, cached 15 min)
Amount (double), From_Currency (string), To_Currency (string), Round_To (object) [optional]
=exl_Currency_Convert_Live(100, A1, A1, ...)
exl_Currency_Rate
Currency
Get current exchange rate between two currencies (requires internet, cached 15 min)
From_Currency (string), To_Currency (string)
=exl_Currency_Rate(A1, A1)
exl_Summary_By_Period
Data Analysis
Aggregate date-value data into weekly, monthly, or quarterly summaries with business-day and calendar-day averages. Optionally pick a preset work schedule, or override week start day, work-day count, and gap-day handling explicitly.
Data_Range (object), Period (string), Schedule (object) [optional], Week_Start_Day (object) [optional], Work_Day_Count (object) [optional], Count_Gap_Days (object) [optional]
=exl_Summary_By_Period(A1, A1, A1, ...)
exl_Data_Credit_Card
Data Utilities
Format a credit card number with spaces, dashes, or no formatting. Optionally mask all but the last N digits.
Card_Number (object), Format (double) [optional], Mask_Digits (double) [optional]
=exl_Data_Credit_Card(A1, 100, 100)
exl_Data_Email
Data Utilities
Email utility for already-delimited email inputs. Return_Type: "Clean" (default, trim+lowercase a single email), "Count" (count emails in a comma/semicolon-delimited string), "Validate" (TRUE only if every email validates), "List" (split into a vertical spill array)
Email_Or_Text (object), Return_Type (object) [optional]
=exl_Data_Email(A1, A1)
exl_Data_Email_Domain
Data Utilities
Extract the domain from an email address. Optionally prefix with 'www.' or 'https://' to build a URL.
Email (object), Include_WWW (object) [optional], Include_HTTPS (object) [optional]
=exl_Data_Email_Domain(A1, A1, A1)
exl_Data_Email_Find
Data Utilities
Find email addresses embedded in arbitrary text (paragraphs, email bodies, free-form notes) using regex. Returns the first email by default, or all of them joined by a delimiter.
Text (object), Return_All (object) [optional], Delimiter (object) [optional]
=exl_Data_Email_Find(A1, A1, A1)
exl_Data_Phone
Data Utilities
Phone number utility. Return_Type: "Format" (default), "Extension", "Extract", "Validate"
Phone_Or_Text (object), Return_Type (object) [optional], Format (object) [optional], Option (object) [optional], Delimiter (object) [optional]
=exl_Data_Phone(A1, A1, A1, ...)
exl_Data_Roman_From_Number
Data Utilities
Convert an integer to Roman numerals (supports 1-3999).
Number (double)
=exl_Data_Roman_From_Number(100)
exl_Data_Roman_To_Number
Data Utilities
Convert Roman numerals to an integer (I through MMMCMXCIX, i.e., 1 to 3999).
Roman (object)
=exl_Data_Roman_To_Number(A1)
exl_Data_SSN
Data Utilities
Social Security Number utility. Return_Type: "Format" (default), "Validate"
SSN (object), Return_Type (object) [optional], Format (double) [optional]
=exl_Data_SSN(A1, A1, 100)
exl_Data_Zip
Data Utilities
ZIP code utility. Return_Type: "Format" (default), "Validate"
Zip_Code (object), Return_Type (object) [optional], Format (double) [optional]
=exl_Data_Zip(A1, A1, 100)
exl_Date_Day_Of_Week
Date & Time
Get day of week (full name, abbreviation, or number)
Date (object), Start_Of_Week (object) [optional], Format (object) [optional]
=exl_Date_Day_Of_Week(A1, A1, A1)
exl_Date_Difference
Date & Time
Calculate the difference between two dates in various units (years, months, weeks, days)
Start_Date (object), Format (object) [optional], As_Of_Date (object) [optional]
=exl_Date_Difference(A1, A1, A1)
exl_Date_First_Or_Last_Of_Period
Date & Time
Get first or last day of a period ("Week", "Month", "Quarter", "Year"). Set Business_Day="TRUE" to return the nearest business day instead of the calendar boundary.
Date (object), Period (object), Position (object), Business_Day (object) [optional], Fiscal_Start_Month (object) [optional], Holidays (object) [optional]
=exl_Date_First_Or_Last_Of_Period(A1, A1, A1, ...)
exl_Date_Is_Business_Day
Date & Time
Check if a date is a business day (TRUE/FALSE). Optionally provide a holiday list to exclude.
Date (object), Holidays (object) [optional]
=exl_Date_Is_Business_Day(A1, A1)
exl_Date_Quarter
Date & Time
Get fiscal quarter (Q1, 1, First Quarter, or Q1 2025)
Date (object), Fiscal_Start_Month (object) [optional], Format (object) [optional]
=exl_Date_Quarter(A1, A1, A1)
exl_Date_Range_End
Date & Time
Returns just the end date of a window around a center date (center plus days after).
Center_Date (object), Days_After (object)
=exl_Date_Range_End(A1, A1)
exl_Date_Range_Start
Date & Time
Returns just the start date of a window around a center date (center minus days before).
Center_Date (object), Days_Before (object)
=exl_Date_Range_Start(A1, A1)
exl_Date_Range_Start_End
Date & Time
Returns start and end dates for a window around a center date as a 1x2 spill array {start, end}.
Center_Date (object), Days_Before (object), Days_After (object)
=exl_Date_Range_Start_End(A1, A1, A1)
exl_Date_Week_Number
Date & Time
Get ISO week number for a date
Date (object), Week_Start_Day (object) [optional]
=exl_Date_Week_Number(A1, A1)
exl_Date_Week_Start
Date & Time
Returns the first day of the week containing the given date (e.g., the Monday or Sunday before the date).
Date (object), Week_Start_Day (object)
=exl_Date_Week_Start(A1, A1)
exl_Date_Workday_Offset
Date & Time
Add or subtract workdays from a date (excludes weekends and holidays). Use a negative Days value to subtract.
Start_Date (object), Days (double), Holidays (object) [optional]
=exl_Date_Workday_Offset(A1, 100, A1)
exl_Date_Workdays_Between
Date & Time
Count business days between two dates, inclusive of both endpoints (matches NETWORKDAYS). Excludes weekends and holidays. Returns a negative count if End_Date is before Start_Date.
Start_Date (object), End_Date (object), Holidays (object) [optional]
=exl_Date_Workdays_Between(A1, A1, A1)
exl_Fin_Aging_Buckets
Finance
Configurable aging buckets for AR/AP/inventory aging. Returns the dollar or unit value in the matching bucket as a spill array, or returns column headers when Return_Type="H".
Receipt_Date (object), Dollars_Or_Units (object), Months_In_Bucket (object), Regular_Buckets (object), Final_Bucket_Months_Plus (object) [optional], Dollars_Units_Or_Both (object) [optional], Aging_Date (object) [optional], Return_Type (object) [optional]
=exl_Fin_Aging_Buckets(A1, A1, A1, ...)
exl_Fin_Asset_Turnover
Finance
Calculate asset turnover: Revenue / Assets. Pass Total_Assets for snapshot, or leave it blank and pass Beginning_Assets + Ending_Assets to use the average.
Revenue (double), Total_Assets (object) [optional], Beginning_Assets (object) [optional], Ending_Assets (object) [optional]
=exl_Fin_Asset_Turnover(100, A1, A1, ...)
exl_Fin_Breakeven_Price
Finance
Calculate break-even price: (Fixed Costs / Units) + Variable Cost per Unit
Fixed_Costs (double), Variable_Cost_Per_Unit (double), Units (double)
=exl_Fin_Breakeven_Price(100, 100, 100)
exl_Fin_Breakeven_Price_For_Profit
Finance
Calculate required price to achieve target profit
Fixed_Costs (double), Variable_Cost_Per_Unit (double), Units (double), Target_Profit (double)
=exl_Fin_Breakeven_Price_For_Profit(100, 100, 100, ...)
exl_Fin_Breakeven_Quantity
Finance
Calculate break-even quantity: Fixed Costs / (Price - Variable Cost)
Fixed_Costs (double), Price_Per_Unit (double), Variable_Cost_Per_Unit (double)
=exl_Fin_Breakeven_Quantity(100, 100, 100)
exl_Fin_Breakeven_Revenue
Finance
Calculate break-even revenue: Fixed Costs / Margin%
Fixed_Costs (double), Margin_Percent (double)
=exl_Fin_Breakeven_Revenue(100, 100)
exl_Fin_Cash_Ratio
Finance
Calculate cash ratio: Cash / Current Liabilities
Cash (double), Current_Liabilities (double)
=exl_Fin_Cash_Ratio(100, 100)
exl_Fin_Contribution_Margin
Finance
Calculate contribution margin: Price - Variable_Cost (dollars) or (Price - Variable_Cost) / Price (percent)
Price (double), Variable_Cost (double), Return_Type (object) [optional]
=exl_Fin_Contribution_Margin(100, 100, A1)
exl_Fin_Current_Ratio
Finance
Calculate current ratio: Current Assets / Current Liabilities
Current_Assets (double), Current_Liabilities (double)
=exl_Fin_Current_Ratio(100, 100)
exl_Fin_Days_In_Inventory
Finance
Calculate days inventory outstanding (DIO): 365 / (COGS / Average Inventory)
COGS (double), Average_Inventory (double)
=exl_Fin_Days_In_Inventory(100, 100)
exl_Fin_Days_Sales_Outstanding
Finance
Calculate days sales outstanding (DSO): 365 / (Revenue / Average Receivables)
Revenue (double), Average_Receivables (double)
=exl_Fin_Days_Sales_Outstanding(100, 100)
exl_Fin_Debt_To_Assets
Finance
Calculate debt to assets ratio: Total Debt / Total Assets
Total_Debt (double), Total_Assets (double)
=exl_Fin_Debt_To_Assets(100, 100)
exl_Fin_Debt_To_Equity
Finance
Calculate debt to equity ratio: Total Debt / Total Equity
Total_Debt (double), Total_Equity (double)
=exl_Fin_Debt_To_Equity(100, 100)
exl_Fin_EPS
Finance
Calculate earnings per share (EPS): Net Income / Outstanding Shares
Net_Income (double), Outstanding_Shares (double)
=exl_Fin_EPS(100, 100)
exl_Fin_Equity_Multiplier
Finance
Calculate equity multiplier: Total Assets / Total Equity
Total_Assets (double), Total_Equity (double)
=exl_Fin_Equity_Multiplier(100, 100)
exl_Fin_Gross_Profit_Margin
Finance
Calculate gross profit margin: (Revenue - COGS) / Revenue
Revenue (double), COGS (double)
=exl_Fin_Gross_Profit_Margin(100, 100)
exl_Fin_Interest_Coverage
Finance
Calculate interest coverage ratio: EBIT / Interest Expense
EBIT (double), Interest_Expense (double)
=exl_Fin_Interest_Coverage(100, 100)
exl_Fin_Inventory_Turnover
Finance
Calculate inventory turnover: COGS / Average Inventory
COGS (double), Average_Inventory (double)
=exl_Fin_Inventory_Turnover(100, 100)
exl_Fin_Net_Profit_Margin
Finance
Calculate net profit margin: Net Income / Revenue
Net_Income (double), Revenue (double)
=exl_Fin_Net_Profit_Margin(100, 100)
exl_Fin_Operating_Margin
Finance
Calculate operating margin: Operating Income / Revenue
Operating_Income (double), Revenue (double)
=exl_Fin_Operating_Margin(100, 100)
exl_Fin_Price_To_Ratio
Finance
Calculate price-to ratio. Return_Type: "Earnings" (P/E), "Book" (P/B)
Return_Type (string), Stock_Price (double), Per_Share_Value (double)
=exl_Fin_Price_To_Ratio(A1, 100, 100)
exl_Fin_Quick_Ratio
Finance
Calculate quick ratio (acid test): (Current Assets - Inventory) / Current Liabilities
Current_Assets (double), Inventory (double), Current_Liabilities (double)
=exl_Fin_Quick_Ratio(100, 100, 100)
exl_Fin_ROA
Finance
Calculate return on assets (ROA): Net Income / Total Assets
Net_Income (double), Total_Assets (double)
=exl_Fin_ROA(100, 100)
exl_Fin_ROE
Finance
Calculate return on equity (ROE): Net Income / Shareholders' Equity
Net_Income (double), Shareholders_Equity (double)
=exl_Fin_ROE(100, 100)
exl_Fin_ROI
Finance
Calculate return on investment (ROI): (Gain - Cost) / Cost
Gain (double), Cost (double)
=exl_Fin_ROI(100, 100)
exl_Fin_Receivables_Turnover
Finance
Calculate receivables turnover: Revenue / Average Receivables
Revenue (double), Average_Receivables (double)
=exl_Fin_Receivables_Turnover(100, 100)
exl_Fin_Working_Capital
Finance
Calculate working capital: Current Assets - Current Liabilities
Current_Assets (double), Current_Liabilities (double)
=exl_Fin_Working_Capital(100, 100)
exl_Terms_Discount_Percent
Finance
Extract discount percentage from terms (e.g., "2/10 Net 30" returns 0.02 for 2%)
Terms (object)
=exl_Terms_Discount_Percent(A1)
exl_Terms_Due_Date
Finance
Calculate due date from terms. Return_Type: "Payment" (net due), "Discount" (early discount date)
Return_Type (string), Invoice_Date (object), Terms (object), Holidays (object) [optional], End_Of_Month (object) [optional], Adjust_Weekends (double) [optional]
=exl_Terms_Due_Date(A1, A1, A1, ...)
exl_Terms_Mail_By
Finance
Calculate when to mail payment to arrive by due date (subtracts business days for mail transit)
Due_Date (object), Mail_Days (double) [optional], Holidays (object) [optional], Adjust_Weekends (double) [optional]
=exl_Terms_Mail_By(A1, 100, A1, ...)
exl_Math_Apply_Percent
Math Functions
Apply percentage to value. Use positive percent to increase, negative to decrease.
Value (double), Percent (double)
=exl_Math_Apply_Percent(100, 100)
exl_Math_Import_CuFt
Math Functions
Calculate cubic feet from length, width, and height (inches or feet).
Length (double), Width (double), Height (double), Measure_In (double)
=exl_Math_Import_CuFt(100, 100, 100, ...)
exl_Math_Import_Fabric_Per_Container
Math Functions
Calculate the maximum square feet of fabric that fits in a shipping container, given the fabric weight in ounces per square yard and the container size.
Oz_Per_SqYd (double), Container_Size (double)
=exl_Math_Import_Fabric_Per_Container(100, 100)
exl_Math_Import_SqFt
Math Functions
Calculate square feet from length and width dimensions (inches or feet).
Length (double), Width (double), Measure_In (double)
=exl_Math_Import_SqFt(100, 100, 100)
exl_Math_Percent_Change
Math Functions
Calculate percentage change: (New Value - Old Value) / Old Value
Old_Value (double), New_Value (double)
=exl_Math_Percent_Change(100, 100)
exl_Math_Reverse_Percent
Math Functions
Calculate the original value from a new value and the percentage change applied to it. Reverses exl_Math_Apply_Percent.
New_Value (double), Percent_Change (double)
=exl_Math_Reverse_Percent(100, 100)
exl_Math_Round_To
Math Functions
Round to nearest multiple (5, 10, 25, etc.) with direction control
Value (double), Multiple (double), Direction (double) [optional]
=exl_Math_Round_To(100, 100, 100)
exl_Math_Sum_Every_Nth_Column
Math Functions
Sum every Nth column in a range (e.g., N=1 sums all, N=2 every other, N=3 every third)
Range (object), N (double), Start_Column (double) [optional]
=exl_Math_Sum_Every_Nth_Column(A1, 100, 100)
exl_Pricing_Cost_From_Price
Pricing
Calculate cost from price. Return_Type: "Markup", "Margin"
Return_Type (string), Price (double), Percent (double)
=exl_Pricing_Cost_From_Price(A1, 100, 100)
exl_Pricing_Discount_Amount
Pricing
Calculate discount amount: Original Price × Discount%
Original_Price (double), Discount_Percent (double)
=exl_Pricing_Discount_Amount(100, 100)
exl_Pricing_Discount_Apply
Pricing
Apply a discount to a price: Original Price × (1 - Discount%). Returns the new (post-discount) price.
Original_Price (double), Discount_Percent (double)
=exl_Pricing_Discount_Apply(100, 100)
exl_Pricing_Discount_Percent
Pricing
Calculate discount percentage: (Original - Sale) / Original
Original_Price (double), Sale_Price (double)
=exl_Pricing_Discount_Percent(100, 100)
exl_Pricing_Discount_Reverse
Pricing
Reverse a discount to find the original price: Sale Price / (1 - Discount%)
Sale_Price (double), Discount_Percent (double)
=exl_Pricing_Discount_Reverse(100, 100)
exl_Pricing_Gross_Profit_Dollars
Pricing
Calculate gross profit in dollars (price minus cost)
Price (double), Cost (double)
=exl_Pricing_Gross_Profit_Dollars(100, 100)
exl_Pricing_Import_Landed_Cost
Pricing
Calculate total landed cost per unit from Incoterm price (FOB, C&F, CIF, LDP, DLV). All cost inputs are per-unit dollars; rate inputs are decimals.
Incoterm_Price (double), Duty_Rate (double), Ocean_Freight (double), Inland_Freight (double), Insurance_Rate (double), Incidental_Rate (double), Incoterm (string), Misc_Charges (double) [optional]
=exl_Pricing_Import_Landed_Cost(100, 100, 100, ...)
exl_Pricing_Import_Price_From_Landed_Cost
Pricing
Calculate supplier price at specified Incoterm working back from a target landed cost (FOB, C&F, CIF, LDP, DLV). All cost inputs per-unit; rate inputs are decimals.
Landed_Cost (double), Duty_Rate (double), Ocean_Freight (double), Inland_Freight (double), Insurance_Rate (double), Incidental_Rate (double), Incoterm (string), Misc_Charges (double) [optional]
=exl_Pricing_Import_Price_From_Landed_Cost(100, 100, 100, ...)
exl_Pricing_Import_Price_From_Sales_Price
Pricing
Calculate the supplier Incoterm price needed to hit a selling price and a target gross profit percentage. All cost inputs per-unit; rate inputs are decimals.
Selling_Price (double), Target_GP_Percent (double), Duty_Rate (double), Ocean_Freight (double), Inland_Freight (double), Insurance_Rate (double), Incidental_Rate (double), Incoterm (string), Misc_Charges (double) [optional]
=exl_Pricing_Import_Price_From_Sales_Price(100, 100, 100, ...)
exl_Pricing_Margin_After_Discount
Pricing
Calculate margin percentage after discount is applied
Original_Margin (double), Discount_Percent (double)
=exl_Pricing_Margin_After_Discount(100, 100)
exl_Pricing_Markup_After_Discount
Pricing
Calculate markup percentage after discount is applied
Cost (double), Original_Price (double), Discount_Percent (double)
=exl_Pricing_Markup_After_Discount(100, 100, 100)
exl_Pricing_Markup_Margin_Convert
Pricing
Convert between markup and margin percentages. Return_Type: "MarkupToMargin", "MarginToMarkup"
Return_Type (string), Percent (double)
=exl_Pricing_Markup_Margin_Convert(A1, 100)
exl_Pricing_Markup_Or_Margin
Pricing
Calculate markup or margin percentage from cost and price. Return_Type: "Markup", "Margin"
Return_Type (string), Cost (double), Price (double)
=exl_Pricing_Markup_Or_Margin(A1, 100, 100)
exl_Pricing_Price_From_Cost
Pricing
Calculate price from cost. Return_Type: "Markup", "Margin"
Return_Type (string), Cost (double), Percent (double)
=exl_Pricing_Price_From_Cost(A1, 100, 100)
exl_Pricing_Retail_From_Wholesale
Pricing
Calculate retail price needed for a desired margin: Wholesale / (1 - Desired Margin)
Wholesale_Price (double), Desired_Margin (double)
=exl_Pricing_Retail_From_Wholesale(100, 100)
exl_Pricing_Retail_Keystone
Pricing
Calculate keystone price (Wholesale Cost × 2). Standard 100% retail markup.
Wholesale_Cost (double)
=exl_Pricing_Retail_Keystone(100)
exl_Pricing_Retail_Markup
Pricing
Calculate retail markup percentage. Return_Type: "Initial" (markup on new product) or "Maintained" (markup after discounts and markdowns)
Return_Type (string), Cost (double), Price (double)
=exl_Pricing_Retail_Markup(A1, 100, 100)
exl_Pricing_Retail_To_Wholesale
Pricing
Calculate wholesale price working back from retail and the retailer's margin: Retail × (1 - Retailer Margin)
Retail_Price (double), Retailer_Margin (double)
=exl_Pricing_Retail_To_Wholesale(100, 100)
exl_States_Lookup
Reference Data
Look up US state: supply name to get abbreviation, or abbreviation to get name. Optionally include capital.
State_Or_Abbreviation (object), Include_Capital (object)
=exl_States_Lookup(A1, A1)
exl_States_Lookup_Headers
Reference Data
Returns column headers for State.Lookup: [State/Abbreviation, Capital] based on input type
Input_Type (object)
=exl_States_Lookup_Headers(A1)
exl_Text_Change_Case
Text Functions
Convert text case. Case_Type: "Upper", "Lower", "Title", "Proper", "Sentence" (default: "Proper")
Text (object), Case_Type (object) [optional]
=exl_Text_Change_Case(A1, A1)
exl_Text_Clean_Whitespace
Text Functions
Remove extra whitespace (trim, collapse multiple spaces to single)
Text (object)
=exl_Text_Clean_Whitespace(A1)
exl_Text_Count_Characters
Text Functions
Count characters in text with options for spaces, line breaks, and character type filtering
Text (object), Include_Spaces (object) [optional], Include_LineBreaks (object) [optional], Count_Type (object) [optional]
=exl_Text_Count_Characters(A1, A1, A1, ...)
exl_Text_Count_Words
Text Functions
Count words in text
Text (object)
=exl_Text_Count_Words(A1)
exl_Text_Currency_Words
Text Functions
Convert a currency amount to all-caps English words for printing on checks (e.g., 'ONE HUNDRED & 00/100'). Set Length to pad to a fixed width like 70 to fill a check line with asterisks.
Amount (double), Length (double) [optional]
=exl_Text_Currency_Words(100, 100)
exl_Text_Extract_Digits
Text Functions
Extract digits only from text (e.g., "ABC-123" returns "123")
Text (object)
=exl_Text_Extract_Digits(A1)
exl_Text_Extract_Letters
Text Functions
Extract letters only from text (e.g., "ABC-123" returns "ABC")
Text (object), Include_Spaces (object) [optional]
=exl_Text_Extract_Letters(A1, A1)
exl_Text_Extract_URL
Text Functions
Extract URL(s) from text
Text (object), Return_All (object) [optional], Delimiter (object) [optional]
=exl_Text_Extract_URL(A1, A1, A1)
exl_Text_Get_Word
Text Functions
Get Nth word from text (1=first, -1=last)
Text (object), Word_Number (double)
=exl_Text_Get_Word(A1, 100)
exl_Text_Legal_Format
Text Functions
Convert number to legal format: fifty-five (55) or fifty-five and five tenths (55.5)
Number (double)
=exl_Text_Legal_Format(100)
exl_Text_Readable
Text Functions
Convert database field names to readable text ("ItemCode" -> "Item Code", "Value_Under12Mos" -> "Value Under 12 Mos")
Text (object), Output_Case (object) [optional]
=exl_Text_Readable(A1, A1)
exl_Text_Remove
Text Functions
Remove all occurrences of a substring from text. Optionally case-insensitive.
Text (object), Substring (object), Ignore_Case (object) [optional]
=exl_Text_Remove(A1, A1, A1)
exl_Text_Reverse
Text Functions
Reverse a text string (e.g., "Hello" becomes "olleH")
Text (object)
=exl_Text_Reverse(A1)
exl_Text_Split
Text Functions
Split text by delimiter and return Nth part (1=first, -1=last)
Text (object), Delimiter (string), Part_Number (double)
=exl_Text_Split(A1, A1, 100)
exl_Text_Split_Name
Text Functions
Split name into First, Middle, Last, Suffix, Credentials. Return_Type: "All", "First", "Middle", "Last", "Suffix", "Credentials", "Headers"
Name_Or_Range (object), Return_Type (object) [optional]
=exl_Text_Split_Name(A1, A1)
exl_Conversions_Distance
Unit Conversions
Convert distance. Units: 0="m" (default), 1="cm", 2="mm", 3="km", 4="in", 5="ft", 6="yd", 7="mi"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Distance(100, A1, A1)
exl_Conversions_Fabric_Linear
Unit Conversions
Convert between fabric areal weight (OzSqYd) and linear measurements (YardsPerLb, LbsPerYard). Requires fabric width in inches because converting between areal and linear density depends on width. Pairs with exl_Conversions_Fabric_Weight.
Value (double), From_Unit (object), To_Unit (object), Fabric_Width_Inches (double)
=exl_Conversions_Fabric_Linear(100, A1, A1, ...)
exl_Conversions_Fabric_Weight
Unit Conversions
Convert fabric weight. Units: 0="GSM" (default), 1="OzSqYd", 2="OzSqM", 3="GramsSqYd"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Fabric_Weight(100, A1, A1)
exl_Conversions_Temperature
Unit Conversions
Convert temperature. Units: 0="C" Celsius (default), 1="F" Fahrenheit, 2="K" Kelvin
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Temperature(100, A1, A1)
exl_Conversions_Weight
Unit Conversions
Convert weight. Units: 0="g" (default), 1="kg", 2="mg", 3="oz", 4="lb", 5="ton", 6="tonne"
Value (double), From_Unit (object), To_Unit (object)
=exl_Conversions_Weight(100, A1, A1)