DocHub makes it quick and straightforward to clean up comma in spreadsheet. No need to instal any software – simply upload your spreadsheet to your profile, use the simple drag-and-drop editor, and quickly make edits. You can even use your desktop or mobile device to modify your document online from anywhere. That's not all; DocHub is more than just an editor. It's an all-in-one document management solution with form constructing, eSignature capabilities, and the option to allow others fill out and eSign documents.
Each file you upload you can find in your Documents folder. Create folders and organize records for easier search and access. Furthermore, DocHub ensures the safety of all its users' data by complying with strict protection standards.
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