I'm trying to strip (or extract data) from columns in Excel. I'm not a power-user, although have done exactly what I want to do now in Python before but can't do so this time...
""slip""=>""20.0300006866455"" ""depth""=>""8.30000019073486""
Above are two sample columns, I want to remove everything except the numbers. As I said, I know you can do so using the strip() function in Python but after a bit of googling - doesn't look like I can do the same in VBA? I have tried Text-Column by delimiter and it is too messy. Any tips would be appreciated, I'm fully aware the answer is probably simple...
Cheers!
Do you want to remove those quotes inside the cell? Do all the cells have same formatting? If so you could just select the entire column, then use find and replace option of excel to change as you want: Find : "" Replace with : (leave it empty)
Click replace all --
This will do your need in seconds. Hope this helps!