Many people find the process to take out comma in XPS quite difficult, especially if they don't often deal with paperwork. Nevertheless, today, you no longer need to suffer through long tutorials or wait hours for the editing software to install. DocHub enables you to change documents on their web browser without setting up new applications. What's more, our powerful service provides a complete set of tools for comprehensive document management, unlike numerous other online tools. That’s right. You no longer have to export and import your templates so frequently - you can do it all in one go!
No matter what type of document you need to alter, the process is simple. Benefit from our professional online solution with DocHub!
hi everyone and welcome to another video by excel tips in this video you will see how to convert a excel column or a data in an excel column to comma separated values like this there can be many scenarios where you might want to convert an excel column to comma separated list for example if you want to send this data to a sql query there are multiple methods to convert this excel column into this comma separated list but we will demonstrate one of the quicker and the simpler methods using the concatenation formula now this method can also be used for any not only commas so you can use this method with semicolons pipes etc and we will also look at how to achieve that so let us now jump right into it so let us now start by having a looking at look at the values that we want so we have values in column a and it starts from in cell a2 and goes all the way to a41 to convert these values which are there into a comma separated list so we can do that very quickly in a two-step process the firs