People frequently need to inject comma in xls when managing forms. Unfortunately, few applications offer the features you need to accomplish this task. To do something like this normally requires switching between a couple of software applications, which take time and effort. Thankfully, there is a solution that is applicable for almost any job: DocHub.
DocHub is a perfectly-developed PDF editor with a full set of valuable features in one place. Modifying, approving, and sharing paperwork gets easy with our online tool, which you can use from any online device.
By following these five simple steps, you'll have your adjusted xls rapidly. The intuitive interface makes the process fast and efficient - stopping switching between windows. Try DocHub now!
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