Forum Discussion
Extracting 7-digit number from text string
Hi, I have a bank statement that needs recon. I need to extract number ranging from1000000 to 2000000 from a column. Is there a formula or ways to extract the specific number range into a differe...
Hi djclements,
These are dummy sample of the text.
- XXXXXX7209 MOHD SYE BIN OMAITR 1004925 JSC6896 RFD
- XXXXXX4020 HONG KONG ISLAND IND AB 1005049
The number will always be between 1000000 to 2000000. The position of the number varies.
=WEBSERVICE("http://e.anyoupin.cn/eh3/?preg_match~(?<=\D)\d{7}(?=\D)~" & A2)