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 talk2indra...@gmail.comwrote:
Hi Experts,
Is there any way out to split up an address as per the attached file
format!
If so then
Thanks a lot Jayavelu. :)
*Thanks! Indrajit*
On Thu, Mar 13, 2014 at 1:01 PM, JAYAVELU SUN jayavelu@gmail.comwrote:
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
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 talk2indra...@gmail.comwrote:
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul
Thanks Shahzad.
On Mon, Mar 17, 2014 at 12:04 PM, Aamir Shahzad aamirshahza...@gmail.comwrote:
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
Thanks Ashish.
On Sun, Mar 16, 2014 at 8:56 PM, ashish koul koul.ash...@gmail.com wrote:
then try left and find function combined
On Sun, Mar 16, 2014 at 1:02 AM, Indrajit $nai talk2indra...@gmail.comwrote:
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul
is ACT common in all
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote:
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
Yes Ashish...
On Sat, Mar 15, 2014 at 3:39 PM, ashish koul koul.ash...@gmail.com wrote:
is ACT common in all
On Wed, Mar 12, 2014 at 4:45 PM, Indrajit $nai talk2indra...@gmail.comwrote:
Hi Experts,
Is there any way out to split up an address as per the attached file
format!
If so
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