Search: "text functions"

#excel #power-query #data-cleanup

Excel: Clean a Messy Address Column Without Losing Edge Cases

I have a column of free-text addresses scraped from a form: [PASTE 20 SAMPLES]. ...

#excel #data-cleaning #names

Clean a Messy Excel Customer List Where Names Are in Six Different Formats

I have an Excel sheet with about 4,000 customer records. The Name column is a di...

writing Beginner

Rewrite Corporate Jargon Into Something a Human Would Actually Say

I have a piece of internal corporate writing that's full of phrases like 'levera...

#writing #tone #jargon

#excel #data cleaning #dates

Clean up a sheet where dates are stored in five different formats

I inherited a spreadsheet where the 'Date' column has dates entered as '3/5/26',...

#excel #pivot-table #data-cleanup

Find the rows that broke a pivot table without scrolling 40,000 rows

My pivot table is showing #N/A or a mysterious 'blank' row, and the source data ...

excel Advanced

Automate Variance-to-Budget Reporting in Excel with LET and LAMBDA

You are an FP&A automation specialist. I have a monthly actuals sheet and a budg...

#lambda #let #variance

design Intermediate

Redesign an empty state from punishment to onboarding moment

You are a UX designer. The empty state of [FEATURE] currently shows 'No items ye...

#design #ux #empty-state

#excel #audit #inherited-model

Audit a spreadsheet a predecessor built before you trust a single number

I inherited an Excel model from someone who left. I need to know if I can trust ...

#excel #template #validation

excel Advanced

Build a self-checking Excel template that catches user-entered errors before they propagate

I'm building a template that non-technical colleagues will fill in monthly. Past...

#excel #performance #recalculation

excel intermediate

Speed up a slow workbook that recalculates every keystroke

Act as an Excel performance specialist. I will describe a workbook that has grow...

#excel #dates #data cleaning

Turn a messy date column into clean, consistent dates in Excel

I have an Excel column of dates entered in mixed formats (some text, some real d...

#marketing #ad copy #advertising

marketing Intermediate

Write High-Converting Ad Copy with Multiple Variations

You are a direct-response copywriter who writes ads that convert. Help me write ...

#marketing #social media #content calendar

marketing Intermediate

Create a Month of Social Media Content from One Theme

You are a social media strategist who helps brands stay consistent without burni...

#creative #video #storyboard

creative Intermediate

Storyboard a 30-Second Video Ad

Storyboard a 30-second video ad for [PRODUCT] targeting [AUDIENCE]. Provide 8 pa...

#discussion-questions #critical-thinking #classroom

education Intermediate

Turn a Boring Reading Into a Discussion Question Set

Turn this reading into a discussion question set that gets students past surface...

#writing #editing #passive-voice

writing Intermediate

Rewrite Passive Voice to Active Voice Editor

Rewrite the following text by converting passive voice constructions to active v...

data Advanced

Cohort Retention Analysis from Event Log

From the event log table with columns user_id, event_name, occurred_at, build a ...

#data #cohort #retention

#design #color #accessibility

design Intermediate

Accessible Color Palette Generator with Contrast Check

Generate an accessible color palette given a brand primary color. Include: prima...

#reengagement #saas #lifecycle

email Intermediate

Write a Layered Re-Engagement Email Sequence for Dormant SaaS Users

Act as a lifecycle marketing strategist. Write me a 4-email re-engagement sequen...

#refactoring #clean-code #testing

coding Intermediate

Refactor a Monolithic Function into Pure, Testable Units

Act as a senior software engineer who pairs with juniors on refactors. I will pa...

excel Advanced

Turn a messy CRM CSV export into a clean Excel dashboard

I will paste a CRM export with inconsistent date formats, duplicate accounts und...

#excel #csv #lambda

#legal #contract review #summary

legal intermediate

Summarize a Contract in Plain English

Act as a legal explainer. Summarize this contract in plain English: [paste contr...

coding Intermediate

Write a regex and explain every piece of it

I need a regex for a specific matching task I'll describe. Write it, then break ...

#coding #regex #patterns