1 min readfrom Microsoft Excel | Help & Support with your Formula, Macro, and VBA problems | A Reddit Community

How can I convert comma-separated numbers into a table automatically?

Hi everyone,

I copied some numbers into Excel and they ended up in a single cell like this:

https://preview.redd.it/emkod0t8hapg1.png?width=489&format=png&auto=webp&s=69d481974a1fd47dfc641c60a9e838c929b1523d

They’re separated by commas, but all the data is inside one cell. What I want is for Excel to automatically turn them into a table like this

https://preview.redd.it/xulaic9bhapg1.png?width=415&format=png&auto=webp&s=1c64681e92ae2d1d8dc1f618c791103eb10916e6

submitted by /u/Reitzor
[link] [comments]

Want to read more?

Check out the full article on the original site

View original article