← Back to the full Prompt Library Productivity

Text-to-Columns Data Splitter

Split messy combined data into separate columns

I have a column with data formatted like this: [paste 2-3 example rows, e.g. "John Smith, john@email.com, 555-1234"]. Tell me how to split this into separate columns for [desired fields] using Text to Columns or a formula.
This is 1 of 459 free prompts
The full library is organised into 15 categories — business, marketing, sales, strategy, study aid, career, small business, and more.
Browse the Full Prompt Library →