Formulas prompts · Data management

Prompts to clean data, write formulas, analyze tables and build reports.

2 prompts

• Data management

  Regex formulas for Google Sheets and Excel, explained and tested

  Extract, validate or replace text with REGEXEXTRACT, REGEXMATCH and REGEXREPLACE: the exact formula for your examples, explained piece by piece, tested on edge cases and applied to a whole column.

  ChatGPT · Claude · Gemini · Microsoft Copilot

  View prompt

• Data management

  Create Excel or Google Sheets formulas

  Describe what you need to calculate and get the exact Excel or Google Sheets formula, explained and with alternatives.

  ChatGPT · Claude · Gemini · Microsoft Copilot

  View prompt