kelvin2088
Board Regular
- Joined
- Mar 11, 2010
- Messages
- 78
Hello experts!
I have thousands rows of data strings like following:
DR612491
AAL313490
7132134ALLI
AALC8214LAN
AD8123LKN8912
.....
I'm wondering if there's any function can help me trim those strings to only numbers? (getting rid of all letters, both in front, back and middle)
so that I can have output like following:
612491
313490
7132134
8214
81238912
Ahh...this is driving me crazy
I have thousands rows of data strings like following:
DR612491
AAL313490
7132134ALLI
AALC8214LAN
AD8123LKN8912
.....
I'm wondering if there's any function can help me trim those strings to only numbers? (getting rid of all letters, both in front, back and middle)
so that I can have output like following:
612491
313490
7132134
8214
81238912
Ahh...this is driving me crazy