How to split only the numbers into separate cells?

For this type of extraction it is more practical to have return numbers as text rather than real numbers.

This formula will extract numbers with "+" sign

=TRIM(RIGHT(SUBSTITUTE(A2,":",REPT(" ",255)),255))

and this one without "+"

=SUBSTITUTE(TRIM(RIGHT(SUBSTITUTE(A2,":",REPT(" ",255)),255)),"+","")

Row\Col	A	B	C
1	Phone/Fax Number	With "+" sign	Without "+", sign
2	Work Phone:+2133388480	+2133388480	2133388480
3	Work Phone:+2133388481	+2133388481	2133388481
4	Work Phone:+2133388482	+2133388482	2133388482
5	Work Fax:+2133388483	+2133388483	2133388483
6	Mobile:+3752961155033	+3752961155033	3752961155033
7	Work Phone:+3751743449381	+3751743449381	3751743449381
8	Work Phone:34466031	34466031	34466031
9	Work Fax:+3751573446022	+3751573446022	3751573446022
10	Work Fax:29965758	29965758	29965758

Hi alkey,
It seems like you're the closest to solution. I might have not been totally clear. All the first 4 rows are in one cell (work phone--->Work Fax). Same for next 5 (Mobile---->Work Fax).
this data was derived from busuiness cards, hence not repeating in the very same patern.
what I could use is function of that kind:
If there is "Work Phone" - a function that would take it out (I don't mind using the first "Work Phone" entry
If there is "Mobile" - same
If there is "work Fax" - same

I believe it is easier to use 3 different functions for 3 different columns.
By the way your function output was always the last number in a cell.

Thanks a lot for your attempts,
Riley

Business Cards.xlsx