i am using a GREP application to search for data in files that match a criteria and I want to get the results into EXCEL
Can i drag and drop or can i pass a selection back from a file to EXCEL?
Also does it matter if the file is already open (Highlight a file on an already open Windows Explorer...
Hello all,
I resurrected an old function someone here helped me build a few years ago but doesn't seem to work in Office 2007. Basically I have a button in a Search tab with this code attached, then I simply enter text into a field (J1) and hit the button.
It will then search a different tab...
I can afford the £200 regex expansion for a simple job, and then have hassle of distributing that.
I need to turn:
fooTest1234foo
into -> Test1234
and things like
foofoo123Test23foofoo
into -> Test23
So that's a del,! and [0-9].
But the [0-9] number could be any length of digits.
I...
We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel
Which adblocker are you using?
Disable AdBlock
Follow these easy steps to disable AdBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the icon in the browser’s toolbar. 2)Click on the "Pause on this site" option.
Go back
Disable AdBlock Plus
Follow these easy steps to disable AdBlock Plus
1)Click on the icon in the browser’s toolbar. 2)Click on the toggle to disable it for "mrexcel.com".
Go back
Disable uBlock Origin
Follow these easy steps to disable uBlock Origin
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.
Go back
Disable uBlock
Follow these easy steps to disable uBlock
1)Click on the icon in the browser’s toolbar. 2)Click on the "Power" button. 3)Click on the "Refresh" button.