View original (French)

Extract first digit from a cell and the following character

Erakmur -  
 Erakmur -
Hello,

I have cells containing, for example:
COL1A-SE R
or
DES3M

I would like to isolate the frequency contained in these characters to obtain:
1A for the first example like 1 year
3M for the second like 3 months.

Therefore, I need a formula that searches for the first digit in my cell and then extracts it with the first character that directly follows it.

Does anyone have a solution?

Best regards

Configuration: Windows XP / Internet Explorer 8.0

3 answers

  1. Mutumbo
     
    Well ...

    If it's variable :

    =MID(A1;MIN(IF(ISNUMBER(SEARCH({0;1;2;3;4;5;6;7;8;9};A1));SEARCH({0;1;2;3;4;5;6;7;8;9};A1);""));2)
    3
  2. Mutumbo
     
    Hi.

    Is the first digit always in the 4th position or can it move around?
    1
  3. Erakmur
     
    The first digit can wander, but you answered my question perfectly. I tested it and it works wonderfully. Thank you very much.
    1