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...
Your formula doesn't work at all, since it contains "curly" quotes instead of straight quotes.
But what should the PIN in example 4 be?
Hi,
we are not talking about in pin them we have to discuss about India Post office pin code number request your support in identifying a formula which will 6 digit capture pin code with spaces and mobile number pin code not with spaces irrespective wherever they are in the address column
What are you asking us, we are unable to understand your question???
Thanks
we are not talking about in pin them we have to discuss about India Post office pin code number request your support in identifying a formula which will 6 digit capture pin code with spaces and mobile number pin code not with spaces irrespective wherever they are in the address column
What are you asking us, we are unable to understand your question???
Thanks
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 understandI give up.
