jonassvaerke

  1. Jyggalag

    Get formula that pulls a number from a sentence in a cell

    Hi all! I have this setup (albeit much larger in reality): Every statement has a sentence with "XYZ employees". Is there a formula that can detect when a sentence says a number, followed by the string value "employees", and then return the value of the number? So that formula can fill out...
    • Jyggalag
    • Thread
    • christian røssel excel ezzzzzzzzzzzz formula help if formula iferror index indexmatch jonas sværke jonassvaerke match olzenmedz sanoj ekrævs sonaj jværke text vlookup vlookup text & values
    • Replies: 5
    • Forum: Excel Questions
  2. Jyggalag

    Use macro to delete files from folder?

    Hi all, I currently have a data overview that draws data through power query from a folder in my windows computer: However, I plan to update this folder rapidly every week and I was wondering if it would be possible to create two macros attached to VBA codes, where they do the following: 1)...
    • Jyggalag
    • Thread
    • delete delete file easy excel fast folder goldstrome help hlookup index indexmatch jonassvaerke jyggalag macro match olzen olzenmedz sverk sverknation svorkieboy svorknation vba vlookup xlookup yonasreppenk
    • Replies: 2
    • Forum: Excel Questions
  3. Jyggalag

    Expand name of files in folder?

    Hi all, I have my folder here: Anybody got any idea how I can expand the files names that end with "file name 1...", "file name 2..." etc.? So I can see the full name would be nice if there was an easy solution that did it aggregately as well thank you all!! :)

We've detected that you are using an adblocker.

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.
Go back
Back
Top