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

Tagged with

#Excel alternatives for data analysis
#Excel compatibility
#Excel alternatives
#generative AI for data analysis
#rows.com
#natural language processing for spreadsheets
#big data management in spreadsheets
#conversational data analysis
#real-time data collaboration
#intelligent data visualization
#data visualization tools
#enterprise data management
#big data performance
#data analysis tools
#data cleaning solutions
#Excel
#comma-separated
#table
#numbers
#cell
How can I convert comma-separated numbers into a table automatically?