Good day,
Is there a formula that can extract only the numbers form text. The below data is an example of what I get. I would like to just extract only the numbers, really what I only need is the Lat & long numbers. But I could always just filter out the rest of the numbers that are not needed. What I do now is just copy the data and manually delete the rest of the data, sometimes it can be very time consuming. The data I get comes in different forms and lengths, due to the fact that different people are inputting it.
So on the first row I would like to extract only -114.535322,33.703122;-114.535723,33.703225
2nd only -114.535322,33.703122;-114.535723,33.703225
3rd row 34.66788,-116.911;33.91927,-117.121;34.6678750286,-115.910988308;34.919265064,-116.120988073
<colgroup><col></colgroup><tbody>
</tbody>
Is there a formula that can extract only the numbers form text. The below data is an example of what I get. I would like to just extract only the numbers, really what I only need is the Lat & long numbers. But I could always just filter out the rest of the numbers that are not needed. What I do now is just copy the data and manually delete the rest of the data, sometimes it can be very time consuming. The data I get comes in different forms and lengths, due to the fact that different people are inputting it.
So on the first row I would like to extract only -114.535322,33.703122;-114.535723,33.703225
2nd only -114.535322,33.703122;-114.535723,33.703225
3rd row 34.66788,-116.911;33.91927,-117.121;34.6678750286,-115.910988308;34.919265064,-116.120988073
BA:River Station :-114.535322,33.703122;-114.535723,33.703225 |
RA1:Phase 1: South River to City Sta.:-115.535708,33.603232;-116.277784,33.68357519 |
Modified Per WOT 125900. AT: Phase 3 (Cat City ), 34.66788,-116.911;33.91927,-117.121(WGG54);34.6678750286,-115.910988308;34.919265064,-116.120988073(NAT53), WOT: 802 Thank you in advance |
<colgroup><col></colgroup><tbody>
</tbody>