Hi,

So far, I managed to find a formula that can do this, however, if the cell contains characters such as "-" it will return #VALUE error. This is the formula:

=1*MID(F20,MATCH(TRUE,ISNUMBER(1*MID(F20,ROW($1:$9),1)),0),COUNT(1*MID(F20,ROW($1:$9),1)))


It will return 1234 from cell F20 which contains abc1234.

How can I change the formula so that it returns 1234 even if cell F20 contains abc-1234?

Thanks