ton

  1. M

    Extract numbers from alphanumeric strings

    Hi all, how can I extract (by VBA) this numbers: 149575 191368 191369 with prefix "DUD" and suffix "/nn" from alphanumeric strings with so DB: DUD 149575/18 DUD 191368/17 Ton 39.00, DUD 191369/18 Ton 9.04 Tia. Maurizio
  2. M

    Editing alphanumeric String (with $ like separator)

    Hi all, I have this data: 169$XRIF 320246/16 XRIF 304641/17 PRY 609295/17 TON 22,34$PRY 609296/17 TON 4,62 380$DUC 160370/17$DUC 160371/17 how can I get this (with vba): 169 XRIF 320246/16 XRIF 304641/17 PRY 609295/17 TON 22,34 PRY 609296/17 TON 4,62 380 DUC 160370/17 DUC 160371/17 Tia. Mau
  3. O

    Start from Sheet 1

    Hi Guys, I need a VBA code that when executed it will do as mentioned below: - When I click on 'add sheet' button It will start from Sheet 1, instead of Sheet (x). Please let me know if this is possible or if you need any clarification from my end. Thanks a ton.
  4. R

    IF/OFFSET Function not working properly

    Currently I have been using this function plenty of times; however, when adding the additional if statements to the OFFSET it is causing errors. I have tried it multiple ways and simply want to drag down to retrieve the information for customers. The error it gives me now that I have a bunch...

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