Text cells need splitting and joining by formula
Text in one cell mixed or combined with other values must be split, joined, extracted or reformatted by formula, which is hard.
Tier I · Proven The best-established problems.
7 public reports · first reported 24 January 2019 · last reported 18 February 2025
What's going wrong
Users often receive or keep text where several values are packed into one cell, such as lists of names, abbreviated amounts with M or B suffixes, or scores that must read as a sentence.
AI-assisted: written with the help of AI from the reports. The idea report has the full summary.
In the idea report
- The full summary.
- The products the 7 reports are about, and how many came each month.
- Related problems.
No business has been found with this problem yet, so the report has no contacts. All sales are final — no refunds. Pricing.