numeric values extracting

  1. R

    Outlook attachment + Numeric Cell

    Hi all, I am trying to create an email where attachment has a some generic folder path but with cell value changes the final folder location example "\\server\nextfolder\nextfolder" & finalfoldername add all files in folder as attachment in email but I want my finalfoldername to be a...
  2. D

    print numeric and alphanumeric value

    Hello everyone i have developed to send a email via outlook the code seems to be fine ,but i just have small problem , i have to print numeric and alpha numeric value from the cell but my code doesn't allow to do that, it shows error. the code is working fine when i use alphabets in the cell but...
  3. D

    Replacing Alpha Characters (english + non english) with single space.

    Hi, Looking for an easy solution to my data, which have cells consisting Numbers, alpha characters, symbols, again numbers. The location of numbers are not fixed, and sometime there is alpha characters , numbers, alpha characters, numbers, ... Question: how can i replace all the alpha...
  4. R

    extracting numberic values from text

    Is there a formula to extract a numberic value from a cell containing both text and numbers? I have a list of my retail stores which contain their "store number" and their "address" but not always in the same order and because they are all different addresses the length is different for each...

Watch MrExcel Video

This Week's Hot Topics

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
Top