FG
💻 Software

How do I separate a comma-separated list into two columns in Excel?

Fresh7 days ago
Mar 15, 2026258959 views
Confidence Score0%
0%

Problem

I have a long, comma-separated list which looks like this in Excel: Is there a simple way to convert this into two separate columns? There are over 800 values, and I am really not looking forward to separating them all individually.

Error Output

401.50,0.027  
402.00,0.028  
402.50,0.029  
403.00,0.031  
403.50,0.032  
404.00,0.034  
404.50,0.037

Unverified for your environment

Select your OS to check compatibility.

1 Fix

Canonical Fix
Unverified Fix
New Fix – Awaiting Verification

Fix for: How do I separate a comma-separated list into two columns in Excel?

Low Risk

Have you tried using Text to Columns? Highlight the column that contains your list. Go to Data > Text to Columns. Choose Delimited. Click Next. Choose Comma. Click Next. Choose General or Text, whichever you prefer. Leave Destination as is, or choos…

Awaiting Verification

Be the first to verify this fix

Sign in to verify this fix

Environment