Clean up the phone number

[msantoso]

hi everyone, 

I need to clean up a phone number column which contains phone numbers but not only! :)

for the following cases, I need some help

- the name of the contact is preceeding the phone number. The length of the name is always different. the only similar case is that the phone number is preceeded with a blank space. 

          ex: Ms Marple 0176/123456789

- two phone numbers in the same cell separated with a dash or a single letter 

thank you very much for your help

Myriam

[msantoso]

dear David, 

you're a real magician!

thank you for this recipe and for this teaching lesson!

best regards

myriam

[msantoso]

Hi David, 

sorry for my late answer...

thanks a million times! this recipe is working great !

myriam