udprocks Member Jul 25, 2018 #1 Dear all, i just need a help , i want to extract zip codes from a column with different condition , very confused is this possible or not i have attached sample sheet for clear instruction. Attachments extract.xlsx 8.7 KB · Views: 8
Dear all, i just need a help , i want to extract zip codes from a column with different condition , very confused is this possible or not i have attached sample sheet for clear instruction.
Belleke Well-Known Member Jul 25, 2018 #2 See if this helps. Example Formula in column D UDF in module1 Attachments extract.xlsm 15.8 KB · Views: 4
B bosco_yip Excel Ninja Jul 25, 2018 #3 Formula solution In C2, copied down : =IFERROR(MID(A2,MATCH(6,FREQUENCY(ROW($1:$99),ISERR(-MID(A2&-10^9,ROW($1:$99),1))*ROW($1:$99)),)-5,5),"") Regards Bosco Attachments Extract5Digit.xlsx 11.4 KB · Views: 4
Formula solution In C2, copied down : =IFERROR(MID(A2,MATCH(6,FREQUENCY(ROW($1:$99),ISERR(-MID(A2&-10^9,ROW($1:$99),1))*ROW($1:$99)),)-5,5),"") Regards Bosco
udprocks Member Jul 25, 2018 #4 Belleke said: See if this helps. Example Formula in column D UDF in module1 Click to expand... Thank you very much sir you are great.
Belleke said: See if this helps. Example Formula in column D UDF in module1 Click to expand... Thank you very much sir you are great.
udprocks Member Jul 25, 2018 #5 bosco_yip said: View attachment 53850 Formula solution In C2, copied down : =IFERROR(MID(A2,MATCH(6,FREQUENCY(ROW($1:$99),ISERR(-MID(A2&-10^9,ROW($1:$99),1))*ROW($1:$99)),)-5,5),"") Regards Bosco Click to expand... thank your for help sir, its awesome .
bosco_yip said: View attachment 53850 Formula solution In C2, copied down : =IFERROR(MID(A2,MATCH(6,FREQUENCY(ROW($1:$99),ISERR(-MID(A2&-10^9,ROW($1:$99),1))*ROW($1:$99)),)-5,5),"") Regards Bosco Click to expand... thank your for help sir, its awesome .
