I have a column with mobile phone numbers as well as landlines:

0403920493
02 9345 9483
93545493

I need a formula to split up the mobile numbers and the landlines. It could either work by:
- First splitting off the numbers that begin with '02', then apply another formula to split the ones that begin with '9' - I will then merge to the landlines columns that I just created
- Split off any numbers that begin with either '02' or '9'

What I don't want is for the formula to rather split off any numbers that begin with '04'.

Thanks!