Leaderboard Ad728 × 90AdSense placeholder — will activate after approval

Search: "text functions"

242 prompts matching "text functions"

"text functions" ✕ Clear all ✕
excel Intermediate

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...

#excel #dates #data cleaning
👁 3 views
excel Beginner

Clean and Deduplicate a Messy Excel Contact List

Act as an Excel data-cleaning specialist. I have a contact list with inconsisten...

#excel #data cleaning #deduplicate
👁 3 views
data Beginner

Design a Clean Data Collection Spreadsheet or Schema

You are a data architect who helps people set up clean data from the start so it...

#data #schema #spreadsheet
👁 3 views
excel Intermediate

Diagnose Why a Pivot Table Is Showing the Wrong Totals

Help me diagnose why my Excel pivot table is showing wrong totals. Source data r...

#pivot-table #debugging #totals
👁 2 views
excel Intermediate

Convert a Messy CSV Export Into a Clean Excel Table

Help me clean a messy CSV export from [SYSTEM NAME] and turn it into an Excel Ta...

#power-query #csv #data-cleaning
👁 2 views
design Intermediate

Accessible Color Palette Generator with Contrast Check

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

#design #color #accessibility
👁 2 views
excel Intermediate

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 #data cleaning #dates
👁 2 views
data Advanced

Rewrite a slow correlated subquery as a window function

I have a query with a correlated subquery that runs once per row to find each cu...

#SQL #window functions #query optimization
👁 2 views
legal Intermediate

Draft a takedown notice that doesn't read like a threat

Someone copied our content (text + structure) onto their site. I want them to ta...

#legal #copyright #takedown
👁 2 views
In-feed Ad336 × 280AdSense placeholder — will activate after approval
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 #performance #recalculation
👁 2 views
coding Intermediate

Untangle a circular import that the codebase has been living with for years

Act as a refactoring lead. There's a circular import between two modules that th...

#refactoring #imports #modules
👁 2 views
excel beginner

Write Excel Formulas from Plain English

Act as an Excel formula assistant. I will describe what I want to calculate in p...

#excel #formulas #automation
👁 2 views
coding intermediate

Refactor Code for Readability

Act as a clean code expert. Refactor this code to improve readability and mainta...

#coding #refactoring #clean code
👁 2 views
legal intermediate

Summarize a Contract in Plain English

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

#legal #contract review #summary
👁 2 views
writing Intermediate

Rewrite jargon-heavy text so a smart outsider gets it

I'll paste text packed with industry jargon and acronyms. Rewrite it for an inte...

#writing #plain language #jargon
👁 2 views
excel Intermediate

Diagnose why my SUMIFS is returning zero

My SUMIFS formula returns 0 even though I can see matching rows. Ask me to paste...

#excel #sumifs #debugging
👁 2 views
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
👁 2 views
design Intermediate

Write microcopy that guides instead of just labels

I'll give you a button, error, or empty state that currently has bland placehold...

#design #ux writing #microcopy
👁 2 views
coding Advanced

Refactor a Long Function into Clean, Testable Pieces

You are a software craftsperson focused on readable, maintainable code. I will p...

#coding #refactoring #clean code
👁 2 views
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 #ad copy #advertising
👁 2 views
writing Beginner

Rewrite Corporate Jargon into Clear, Human Prose

You are an editor who specializes in stripping jargon from corporate writing. I ...

#editing #plain-language #rewrite
👁 1 views
excel intermediate

Clean Messy Excel Data Step by Step

Act as a data cleaning specialist. My Excel sheet has these issues: [list proble...

#excel #data cleaning #power query
👁 1 views
writing beginner

Rewrite Text to Match a Specific Tone

Act as an expert editor. Rewrite the following text to sound [desired tone, e.g....

#writing #tone #rewrite
👁 1 views
design Intermediate

Get Structured UX Feedback on a Screen or Flow

You are a senior UX designer conducting a heuristic review. I will describe (or ...

#design #ux #usability
👁 1 views
End-of-content Ad728 × 90AdSense placeholder — will activate after approval