Hi,
can we try this also?
=MID(B2,LEN(B2)-14,6)
From
Naveen
On Fri, Mar 28, 2014 at 3:17 PM, joseph liech wrote:
> thanks for your attention.
> please help me.
>
>
> On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote:
>
>> can you provide please sample file.
>>
>> Divaker
>>
>>
>> On Wed,
28, 2014 3:18 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ extracting zip codes from addresses
thanks for your attention.
please help me.
On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey
wrote:
can you provide please sample file.
Divaker
On Wed, Mar 26, 2014 at
Hi Joseph,
Please have a look at attached one.. The formula'll work for 5 digit Zip
code only.
On Fri, Mar 28, 2014 at 3:17 PM, joseph liech wrote:
> thanks for your attention.
> please help me.
>
>
> On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote:
>
>> can you provide please sample fil
thanks for your attention.
please help me.
On Thu, Mar 27, 2014 at 12:05 AM, Divaker Pandey wrote:
> can you provide please sample file.
>
> Divaker
>
>
> On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote:
>
>> hi everyone
>>
>> i have looked around most postings here but none was similar to m
can you provide please sample file.
Divaker
On Wed, Mar 26, 2014 at 5:51 PM, joseph liech wrote:
> hi everyone
>
> i have looked around most postings here but none was similar to my
> situation.
>
> i need help please, or kindly pls suggest me where i can get help.
>
> everyday i received about
hi everyone
i have looked around most postings here but none was similar to my
situation.
i need help please, or kindly pls suggest me where i can get help.
everyday i received about 100 customers' addresses. it is in 1 row for each
address, but all the address details are lumped into 1 cell.
