Let’s see how we could easily extract all the digits after a character in excel.
There are several occasions in which we are given with values that starts with some initial text and then there are numerical values like ids or something.
We will see how we could extract the numeric part after the last character value in a cell in excel.
Above is the data from which we have extracted the numeric part in column B.
Enter the formula below to extract the numeric part after the last character in a cell in excel.
=–MID(A2,MIN(FIND({0;1;2;3;4;5;6;7;8;9},A2&”0123456789″)),99)
The “–” at the beginning of the formula is the unary operator which helps us to convert the value into numeric type.
You could remove the unary operator if you don’t want to convert the values to numeric.
Hope this helped.
