DocHub is an all-in-one PDF editor that lets you inject trait in csv, and much more. You can highlight, blackout, or remove document components, add text and pictures where you need them, and collect information and signatures. And because it works on any web browser, you won’t need to update your device to access its professional features, saving you money. With DocHub, a web browser is all you need to handle your csv.
Sign in to our service and follow these steps:
It couldn't be simpler! Improve your document processing today with DocHub!
Hey welcome back. It is time for another Dueling Excel podcast. I am Bill Jelen from MrExcel. Weamp;#39;ll be joined by Mike Girvin from Excel is Fun. This is our Duel number 193. Add a number to cells with common delimited numbers. Power Query Edition. All right. Same question as last weekamp;#39;s episode 192. Siva has a cell with a bunch of numbers separated by commas. He wants to add another number to all of those numbers. Last week, I did this with VBA. Mike did it with a LET formula. But it could have been done with Power Query. As Mike and I talked about this, we each had a completely different Power Query way to go. So hereamp;#39;s my power query solution. I am going to use Ctrl+T to make this into a table.Then Data, From Table or Range. You see Power Query changes this to scientific notation. So I remove the Change Type step from the applied steps. Under Add Column, I am going to add an index column. Choose amp;quot;From 1amp;quot;. Take this original data and Home, Spli