Google Sheets

CellwellSplit names, split and merge text, change case, clean, extract and fill random data in Google Sheets, with a preview of every change and Undo

Full name: “Cellwell: Split Names, Merge, Change Case & Clean Text”

$15 a month or $50 a year per Google account. Free trial: 30 days or 50 Apply runs, whichever comes first. No card needed.

Cellwell: Split names previewCellwell: Split names doneCellwell: Split text zerosCellwell: Merge own formats

Cellwell does the text jobs Google Sheets makes you write formulas for, right in your cells, and shows you exactly what will change before anything does.

Split names

What you get

  • Split names into title, first, middle, last, suffix and nickname; handles "Last, First", initials, particles like van and de la, and fixes ALL CAPS names
  • Split text by commas, semicolons, spaces, line breaks or your own delimiters (quotes respected), by position, before capitals, or between letters and numbers
  • Merge columns row by row, or a column into one cell, exactly as the values show (your currency and date formats are kept)
  • Change case: Sentence, Title, Capitalize Each Word, UPPER, lower, Name Case (McDonald, O'Brien), tOGGLE; keeps NASA and iPhone
  • Clean extra and non-breaking spaces, invisible characters, line breaks, curly quotes, accents and HTML
  • Add text at any position; remove the first or last characters, some text, kinds of characters, or text before, after or between markers
  • Extract emails, links, domains, phone numbers, numbers, hashtags, mentions, text between markers, or your own pattern
  • Random numbers, dates, TRUE/FALSE, list picks, codes and UUIDs that do exactly what you ticked (unique means unique)
  • Preview every change first; formulas are never overwritten; text like 00123 stays text; Undo any run from History, even after closing the spreadsheet

Questions about Cellwell

What does Cellwell do?

Split names, split and merge text, change case, clean, extract and fill random data in Google Sheets, with a preview of every change and Undo. Cellwell does the text jobs Google Sheets makes you write formulas for, right in your cells, and shows you exactly what will change before anything does.

What does Cellwell work with?

Cellwell works in Google Sheets, in any browser.

How much does Cellwell cost?

$15 a month or $50 a year per Google account. $100 once for lifetime access on one Google account. Billed through Stripe. Cancel any time from Plans and billing in the add-on.

Is there a free trial?

Free trial: 30 days or 50 Apply runs, whichever comes first. No card needed.

How do I get Cellwell?

Email hello@greatwork.company and we'll help you get Cellwell set up.

Who makes Cellwell?

Great Work LLC, an independent software company. Email hello@greatwork.company with any question about Cellwell and a person will answer.


More Google Sheets apps

All 36 Google Sheets apps→