Re: $$Excel-Macros$$ Extracting Zip Code from Address

2013-01-09 Thread The Viper
> > Thanks, > > Jaideep > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Prince > *Sent:* Thursday, January 10, 2013 8:56 AM > *To:* excel-macros@googlegroups.com > *Cc:* noorain.ans...@gma

RE: $$Excel-Macros$$ Extracting Zip Code from Address

2013-01-09 Thread Jaideep Panchal
Of Prince Sent: Thursday, January 10, 2013 8:56 AM To: excel-macros@googlegroups.com Cc: noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ Extracting Zip Code from Address Hi Noorain In case of MAIDSTONE Wells ME14 4EA formula is not working regards prince On Thursday, January 10

Re: $$Excel-Macros$$ Extracting Zip Code from Address

2013-01-09 Thread Prince
> Sent from BlackBerry® on Airtel > -- > *From: * "Jaideep Panchal" > > *Sender: * excel-...@googlegroups.com > *Date: *Thu, 10 Jan 2013 00:58:58 +0530 > *To: *> > *ReplyTo: * excel-...@googlegroups.com > *Cc: *> > *Subject: *$$Excel-Macros$$ Ext

Re: $$Excel-Macros$$ Extracting Zip Code from Address

2013-01-09 Thread noorain . ansari
ject: $$Excel-Macros$$ Extracting Zip Code from Address Hi group, I need some help in extracting zip code from address and hope u all will provide a good help as always... I need some formula to extract text after second last space because town name might have 2-3 words.. Town & Z

$$Excel-Macros$$ Extracting Zip Code from Address

2013-01-09 Thread Jaideep Panchal
Hi group, I need some help in extracting zip code from address and hope u all will provide a good help as always... I need some formula to extract text after second last space because town name might have 2-3 words.. Town & Zip Code Result Required LINCOLN LN4 4SY LN4 4SY LINC