

The new versions of Excel provide a special feature that lets you do that using the ‘Data’ menu. The best way to work through the above two problems is by splitting one column into multiple columns. In other cases, you might have got a list of addresses, but want to organize this data properly so you can clearly see how many of the people reside in, say, New York.


If the volume of the data is very large then it’s usually quite difficult to structure the data’s readability.įor example, you might have got data with a list of names, and you might want to arrange the names in alphabetical order of surnames. However, sometimes you need to work with data that someone else has created. When entering data from scratch, it’s possible to ensure that we structure the data to be more readable. One of the best ways to make your data more readable is to split it into chunks so that it is easier to access the right information. It makes the data easier to skim through and work with.

Recent ClippyPoint Milestones !Ĭongratulations and thank you to these contributors DateĪ community since MaDownload the official /r/Excel Add-in to convert Excel cells into a table that can be posted using reddit's markdown.When working with data and spreadsheets, readability, and structure matter a lot. Include a screenshot, use the tableit website, or use the ExcelToReddit converter (courtesy of u/tirlibibi17) to present your data. NOTE: For VBA, you can select code in your VBA window, press Tab, then copy and paste that into your post or comment. To keep Reddit from mangling your formulas and other code, display it using inline-code or put it in a code-block This will award the user a ClippyPoint and change the post's flair to solved. OPs can (and should) reply to any solutions with: Solution Verified
