Given an alphanumeric string, one may want to perform the following
Extract phone number from the string
Assume a list of customer addresses with multiple phones numbers mentioned in the address field itself. These numbers may be mobile numbers and/or mobile numbers. Furthermore, PIN codes may also be mentioned in the address string.
One may want to extract only the phone numbers to another column.
You may refer to the my solution in this workbook.
Extract one specific 20 digit number from the string
Assume cell descriptions which contains two 20 digit numbers occurring anywhere in the string. Once may want to extract only that 20 digit number which has the word New before it.
You may refer to my solution in this workbook.
Extract number from an alphanumeric string
{ 72 Comments }