Remove letters, keep only numbers
Solved
mike the llama
Posted messages
361
Status
Membre
-
mike the llama Posted messages 361 Status Membre -
mike the llama Posted messages 361 Status Membre -
Hello,
Here’s my challenge for today:
I have a long Excel list of phone numbers that looks like this: “Mobile: 0123456789” (in a single cell) or “Mobile: 0123456789, Home: 0123456789” (in a single cell).
I would like to keep only the Mobile number, that is to say remove "Mobile: " and " , Home: 0123456789".
I want to clarify that I have no experience in VBA or macros, but if there’s no other solution... well, I will manage!
Configuration: Windows XP / Firefox 6.0.2
Here’s my challenge for today:
I have a long Excel list of phone numbers that looks like this: “Mobile: 0123456789” (in a single cell) or “Mobile: 0123456789, Home: 0123456789” (in a single cell).
I would like to keep only the Mobile number, that is to say remove "Mobile: " and " , Home: 0123456789".
I want to clarify that I have no experience in VBA or macros, but if there’s no other solution... well, I will manage!
Configuration: Windows XP / Firefox 6.0.2
