extract numbers letters

  1. K

    Extract 4 digit year from inconsistent string of text

    First posting here so apologies for anything I miss out. I work in an academic library and I'm trying to profile the collection by year published. The only problem is that the dates for academic journals (which span several years) are inputted manually and therefore are written in an infinite...
    • kirksmim
    • Thread
    • extract data from string extract numbers from cell extract numbers letters extract numbers string
    • Replies: 5
    • Forum: Excel Questions
  2. G

    Extract numbers from text into multiple columns

    I hope i am not repeating someone else's question but i couldn't find the answer to my question - I have a column of text strings that i need to extract the numbers out of each text string but not as a long number, instead into separate columns in order to perform a calculation from the various...
  3. B

    Extracting a number from an inconsistant text string

    Hi all, Very good evening... I have an excel stock price template, where I need the current price to calculate the mid point if the chart. This is the text I get from the webquerry Underlying stock: SBIN 2699.00 as on Jul 04, 2014 15:30:36 IST I need a formula to extract the stock price...
    • binoos123
    • Thread
    • excel formula extract numbers letters text to collumns
    • Replies: 13
    • Forum: Excel Questions
  4. G

    Separate elements from numbers in chemical formulas

    Hello, I have looked at many topics on how to separate numbers from letters in different columns, but I couldn´t find a solution for my problem. I need to take a chemical formula in a cell, for example Fe2O3, and separate each element and number into different cells, like: Fe 2 O 3...

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