Extract number from cell into other column corrsponding cell

[tajulit]

Hi All,
I have a worksheet with A-F columns. Some cell has only number, Number with first bracket, number with dot, number with hyphen and number with alphabetic word.

I want cut the number into corresponding cell in Column G but if number with alphabetic word then nothing do.

Example before apply code:
A B C
1. 1788 University Ave Riverside 92507 951-684-0207 uffpufff@yahoo.com
2. Riverside 92507 (951)-684-0207 pfspufff@yahoo.com
3. 951.684.0207 puffpufff@yahoo.com
4. 1788 University Ave Riverside 92507 9516840207 puffpufff@yahoo.com

Output after Applying Code:
G
1. 951-684-0207
2. (951)-684-0207
3. 951.684.0207
4. 9516840207

 

[Rick Rothstein]

I can't edit post after 10 minutes from posting. So how i can include link of cross posting?

Reply to your own message saying that you forgot to mention you cross-posted at so-and-so and then provide the link to your thread. You don't have to do that now since Peter did it for you in Message #6, HOWEVER, you should be nice to the volunteers at the other forum by letting them know of your cross-post.

 

[Peter_SSs]

HOWEVER, you should be nice to the volunteers at the other forum by letting them know of your cross-post.

I've attended to that in the other forum too.