Saturday 29 December 2018

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

I have a long, comma-separated list which looks like this in Excel:


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

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.

No comments:

Post a Comment

Where does Skype save my contact's avatars in Linux?

I'm using Skype on Linux. Where can I find images cached by skype of my contact's avatars? Answer I wanted to get those Skype avat...