DocHub is an all-in-one PDF editor that enables you to revise comma in xls, and much more. You can underline, blackout, or erase document fragments, add text and pictures where you need them, and collect information and signatures. And because it runs on any web browser, you won’t need to update your device to access its robust features, saving you money. With DocHub, a web browser is all you need to make changes in your xls.
Sign in to our website and follow these steps:
It couldn't be simpler! 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
