tag:blogger.com,1999:blog-6799428426680372912.post7848852162129332502..comments2023-11-15T17:26:49.562+05:30Comments on iGoogleDrive: Google Spreadsheet Extract Zip Code from CellKishhttp://www.blogger.com/profile/13751098853627072874noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6799428426680372912.post-69143507754674359392012-10-10T02:54:41.911+05:302012-10-10T02:54:41.911+05:30+tjennnins, I posted this on the thread to see if ...+tjennnins, I posted this on the thread to see if it works on your data:<br /><br />=ArrayFormula(REGEXEXTRACT(M2;{"Pick-up at: [A-Z]+, [A-Z]{2} ([0-9]{5})\n","Deliver to: [A-Z]+, [A-Z]{2} ([0-9]{5})\n"}))Adamhttps://www.blogger.com/profile/03683985213768541116noreply@blogger.comtag:blogger.com,1999:blog-6799428426680372912.post-56422995021360995352012-10-10T02:39:43.318+05:302012-10-10T02:39:43.318+05:30Hi thank you for your reply. The result is only s...Hi thank you for your reply. The result is only showing as 00000. remember there are many strings of numbers in the cell, some are 1 or 2 digits and some are up to 9 digits. I only need the 5 digit zip codes immediately following the statements in my examples.tjenninshttps://www.blogger.com/profile/07508734128865241575noreply@blogger.com