DocHub is an all-in-one PDF editor that enables you to snip comma in xls, and much more. You can highlight, blackout, or erase document fragments, insert text and images where you want them, and collect information and signatures. And since it works on any web browser, you won’t need to update your device to access its professional capabilities, saving you money. With DocHub, a web browser is all it takes to manage your xls.
Sign in to our service and follow these steps:
It couldn't be easier! Enhance your document management now with DocHub!
hi this vid Iamp;#39;ll show you how to split comma-separated values or other delimited data into separate roles so what does that mean letamp;#39;s say we have this is a simple two column table and we see our other column here has items that are separated by commas here and what we want to do so this is the same table but itamp;#39;s not just color-coded here just got some colors and what we want to do is we want to take those items that are separated by commas and break them out into their own rows so you can see here thereamp;#39;s four values here in this column item 14 17 15 8 and 8 for invoice number 1 0 1 1 so we can see what we have our invoice number 1 0 1 1 these four separate rows form and we have 4 separate rows for those item numbers 14 17 15 and 8 alright so theyamp;#39;re all separated instead of commas in their own rows and itamp;#39;s the same here what invoice 15:47 weamp;#39;ve got our range of items that were originally separated by commas in its own row in i
