Thanks a lot Jayavelu. :)
*Thanks! Indrajit*
On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN wrote:
> This is solution for State =MID((RIGHT(A17,8)),1,3)
>
> this is solution of pin code =right(right(A17,4)
>
>
> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
>
>> Hi Experts,
>>
>
This is solution for State =MID((RIGHT(A17,8)),1,3)
this is solution of pin code =right(right(A17,4)
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
> Hi Experts,
>
> Is there any way out to split up an address as per the attached file
> format!
>
> If so then please provide me the f
Thanks Shahzad.
On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad wrote:
> Hi Indrajit,
>
> try this
>
>
> =IF(ISERR(FIND("ACT",A4,FIND("ACT",A4)+1)),LEFT(A4,FIND("ACT",A4)-1),LEFT(A4,FIND("ACT",A4,FIND("ACT",A4)+1)-1))
>
>
> On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai
> wrote:
>
>> Thank
Hi Indrajit,
try this
=IF(ISERR(FIND("ACT",A4,FIND("ACT",A4)+1)),LEFT(A4,FIND("ACT",A4)-1),LEFT(A4,FIND("ACT",A4,FIND("ACT",A4)+1)-1))
On Mon, Mar 17, 2014 at 12:32 AM, Indrajit $nai wrote:
> Thanks Ashish.
>
>
> On Sun, Mar 16, 2014 at 8:56 PM, ashish koul wrote:
>
>> then try left and fi
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul wrote:
> then try left and find function combined
>
>
> On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
>
>> Yes Ashish...
>>
>>
>> On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
>>
>>> is ACT common in all
>>>
>>>
>>> O
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai wrote:
> Yes Ashish...
>
>
> On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
>
>> is ACT common in all
>>
>>
>> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai
>> wrote:
>>
>>> Hi Experts,
>>>
>>> Is ther
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul wrote:
> is ACT common in all
>
>
> On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
>
>> Hi Experts,
>>
>> Is there any way out to split up an address as per the attached file
>> format!
>>
>> If so then please provide me the form
is ACT common in all
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai wrote:
> Hi Experts,
>
> Is there any way out to split up an address as per the attached file
> format!
>
> If so then please provide me the formula or vba code (anything).
>
> Thanks in advance.
>
> --
> Indrajit
>
> Disclaimer
Hi Experts,
Is there any way out to split up an address as per the attached file format!
If so then please provide me the formula or vba code (anything).
Thanks in advance.
--
Indrajit
Disclaimer:
This electronic message and any files transmitted with it are confidential
and intended solely f
