Extract address from all details in cells

[newyorknix]

Hi,
I want to extract the addresses from cells. I tried Find, MID and Right but no luck as I cannot get the common factor.

Cells are like these:

Clark+(74)-(365)-4675837, 4839057, 47589305 +(74)-9933457364, 9485265483Near Green Chapel, Engineers Avenue, Dallas - 564893

Will+(74)-(365)-4675545, 4839368 +(74)-9935467364, 94852594831511 Main Street, Dallas - 564893

Joe+(74)-99357373765315 North Central Expressway, Dallas - 564893

The similarities in all fields:
Mobile numbers are 10 digits and land line numbers 7 digits.
Country code comes before first contact numbers and all fields contain "Dallas"

It will be very helpful if anyone help me to extract only addresses like:

Near Green Chapel, Engineers Avenue
1511 Main Street
5315 North Central Expressway

Removing "Dallas" is not necessary, though.
Thanks in advance
Regards,
Nicks

 

[anandvarma]

try text column & have a look at
REGEX.SUBSTITUTE in Morefunc excel addin

 

[newyorknix]

I am a newbie here...
Do you mean text to column?
Regex how to do that?