Formulas to clean messy data

By Microsoft (profile) · From Microsoft Copilot Scenario Library · License: All rights reserved (Microsoft Terms of Use) · Added October 28, 2026

Suggests sheet formulas to fix spacing and capital letters.

Link only. Microsoft keeps the full prompt on their own site, so it is not copied here.

This is my prompt

Wrote this prompt? Tell me, and I will put your name on it. I check every claim by hand.

Report or remove
What is wrong?

More Money prompts

MoneyFind peopleLink only

Top product groups by revenue

Finds your top three product categories by sales over three years.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

MoneyRun the businessLink only

12-month rolling average

Adds columns to a sheet that show a rolling yearly average.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

MoneyRun the businessLink only

Two-year revenue forecast chart

Forecasts sales by category for two years next to past data in one chart.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

MoneyRun the businessLink only

Key terms from a contract

Asks simple questions of a contract, like the fee, invoicing terms and length.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

MoneyRun the businessLink only

Compare two contracts

Builds a table of the key differences and risks between two contracts.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

MoneyRun the businessLink only

Highlight spend over a limit

Colors cells where spending goes past an amount you set.

You need: any AI chat (ChatGPT, Claude or Grok Bot)

By Microsoft

All Money promptsAll prompts

Want a prompt for your own work? Ask for one. Every prompt here is free.

Want this built for you? Get it built.