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

 

[tajulit]

 

[Rick Rothstein]

Is what you posted all in Column A, or is your data split into Columns A, B and C? If the latter, can you show us more clearly what is in which columns?

 

[tajulit]

Is what you posted all in Column A, or is your data split into Columns A, B and C? If the latter, can you show us more clearly what is in which columns?

Please see attached file of 2nd reply

 

[Rick Rothstein]

Please see attached file of 2nd reply

All I see in Message #2 is a black square with a white X in it.

 

[Peter_SSs]

Cross posted at: [url]http://www.excelforum.com/excel-programming-vba-macros/1112050-extract-number-from-cell-into-other-column-corrsponding-cell.html[/URL]

Cross-posting (posting the same question in more than one forum) is not against our rules. However, for the future, you might note point 24 of our Posting Guidelines, including reading the linked page at the end of that point.

 

[tajulit]

Cross posted at: Extract number from cell into other column corrsponding cell

Cross-posting (posting the same question in more than one forum) is not against our rules. However, for the future, you might note point 24 of our Posting Guidelines, including reading the linked page at the end of that point.

Hi Peter_SSs,

Thanks for pointed me about this rules. I will remember it. Actually i needed a quick solution. So I posted in another forum.

 

[tajulit]

All I see in Message #2 is a black square with a white X in it.

Actually i want cut the cell if it's not contain any alphabetic word.

 

[Peter_SSs]

Actually i needed a quick solution. So I posted in another forum.

Possibly all the more reason to actually read the page that is linked at the end of point 24. Posting in multiple forums sometimes actually slows the response.

 

[tajulit]

Possibly all the more reason to actually read the page that is linked at the end of point 24. Posting in multiple forums sometimes actually slows the response.

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