Forum Discussion
All Versions Formulas and Functions
Hi, Request your support in identifying a formula which i used to extract Pin code formula used by me is only capturing the pincode, however, it fails to capture pincode with spaces and mobile num...
In the first example, the PIN is 676305
In the second example, it is 671 541 (or 671541 if you prefer)
What should the formula return for the 4th example?
Hi,
The first one is right he what the formula should return here is PIN is 676305
The second one is right he what the formula should return here is PIN is 671541 if you prefer
The four is right he what the formula should return here is blank
blank should come because there is no 6 digit number in this column
I hope you have understand
I give up.
I believe the data should look like this. But I can't see the connection with "pin". It's in the Name column, and then in the Address column and then not in any column.
Name Address City State Country 1 ID 1 ID 2 Country 2 PIN……676305 ABU TALHA GRAM TOEAN [OP] TOWN SARAI MEER SARAIMEER AZAMGARH PHULPUR AZAMGARH Uttar Pradesh India 9721994650 9936718425 India PRAVEEN KUMAR K S/O B BALAN NAIR KARUVINCHAYIAM HOUSE KUTTIKOL PO .CHENGALA [VIA] PIN 671 541 KASARAGOD Kerala India 8136920654 9539813011 India PRAVEEN KUMAR K S/O B BALAN NAIR KARUVINCHAYIAM HOUSE KUTTIKOL PO .CHENGALA [VIA] PIN 6715 41 KASARAGOD Kerala India 8136920654 9539813011 India BALKEESHPEGAM NCHIRAHAMMAD C/O NASEERAHAMMAD , NO – 2/477 , THATTAN KULAM STREET , UDAYAMARTHANDAPURAM THIRUVARUR Tamil Nadu India 9688353770 6385508410 India
