legroups.com ] *On Behalf Of *Prince
> *Sent:* Thursday, January 10, 2013 9:44 AM
> *To:* excel-...@googlegroups.com
> *Cc:* jai_...@msn.com
> *Subject:* $$Excel-Macros$$ Re: Extracting Zip Code from Address
>
>
>
> Hi Jai,
>
>
>
> here
Subject: $$Excel-Macros$$ Re: Extracting Zip Code from Address
Hi Jai,
here is your solutoon
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),510))
Regards
Prince
On Thursday, January 10, 2013 12:58:58 AM UTC+5:30, Jai wrote:
Hi group,
I need some help in extr
Hi Jai,
you can also try this
=MID(SUBSTITUTE(A2," ","$",(LEN(A2)-LEN(SUBSTITUTE(A2," ",""))+1)-2),
FIND("$",SUBSTITUTE(A2," ","$",(LEN(A2)-LEN(SUBSTITUTE(A2,"
",""))+1)-2))+1, LEN(A2))
Regards,
Lalit Mohan
On Thursday, 10 January 2013 09:43:43 UTC+5:30, Prince wrote:
>
> Hi Jai,
>
> here is
Hi Jai,
here is your solutoon
=TRIM(RIGHT(SUBSTITUTE(A1," ",REPT(" ",255)),510))
Regards
Prince
On Thursday, January 10, 2013 12:58:58 AM UTC+5:30, Jai wrote:
>
> Hi group,
>
>
>
>
>
> I need some help in extracting zip code from address and hope u all will
> provide a good help as always
