VBA : Remove Number, Extra Spaces, Mark (.) from a Text

[muhammad susanto]

hi all.

i need vba code to remove series number from front text, remove extra spaces, mark dot (.)
i want the code work in any sheet name, cause i want to make code as personal macro/excel add-ins
the code work step:
- select range/cell then click/run macro
here this sample

before run macro	after run macro
1. John We	John We
2. Sisca Madame	Sisca Madame
12.Frans Bonjour	Frans Bonjour
124. Salsa Micro Gav	Salsa Micro Gav

anyone would help me, greatly appreciated..

susanto

 

[muhammad susanto]

hi Peter, thank you!!!

 

[Peter_SSs]

You're welcome.