Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-06 Thread deval desai
U can Use Mid Function for the same
=Mid(Cell Reference, Starting Num, No of Chars)
For eg

Ur Orignal Code is 8900765

U want 765 then fromula is
=mid(cell Ref, 5,3)

Hope this will get result as u want.


On Apr 1, 6:55 pm, "Puttu *"  wrote:
> Can you please please help any one
>
>
>
>
>
> On Fri, Apr 1, 2011 at 5:40 PM, Puttu *  wrote:
> > sorry again, please hep me in the formula
>
> > On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:
>
> >> awaiting for your replay please.
>
> >> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>
> >>> Experts please help me on this it's bit urgent sorry to bother.
>
> >>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>
>  Hi Experts,
>
>  I have list of items which have not full codes. I need them to convert
>  full code. Could you please help me.
>
>  Item code column has either 3, 2, 4 & 5 digits no. but by default they
>  should be either 6 or 7 or 8 digits code. What best formul I need to use 
>  to
>  get that output. Item Full Code output column has the correct answers
>  which I manually entered. I want the same way answer using the formulas
>
>  Item Full Code output
>
>  Give the formula for output
>
>  Item Code
>
>  200990
>
>   990
>
>  200991
>
>   991
>
>     300011
>
>   11
>
>  300014
>
>   14
>
>  300104
>
>   104
>
>     520901
>
>   20901
>
>  520902
>
>   20902
>
>  500450
>
>   450
>
>  500451
>
>   451
>
>     203529
>
>   3529
>
>  203538
>
>   3538
>
>     8515959
>
>   15959
>
>  8516271
>
>   16271
>
>     8203892
>
>   3892
>
>  8203893
>
>   3893
>
>     1620224
>
>   224
>
>  1620225
>
>   225
>
>  --
>  Putta
>
>  --
>
>  ---­---
>  Some important links for excel users:
>  1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
>  2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310
>  3. Excel tutorials athttp://www.excel-macros.blogspot.com
>  4. Learn VBA Macros athttp://www.quickvba.blogspot.com
>  5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com
>
>  To post to this group, send email to excel-macros@googlegroups.com
>
>  <><><><><><><><><><><><><><><><><><><><><><>
>  Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>
> >>> --
> >>> Putta
>
> >> --
> >> Putta
>
> > --
> > Putta
>
> --
> Putta- Hide quoted text -
>
> - Show quoted text -

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread rajan verma
>
>Item Full Code output
>
> Give the formula for output
>
> Item Code
>
> 200990
> =Text(item_Code,"000")
>
>  990
>
> 200991
>
>  991
>
>300011
>
>  11
>
> 300014
>
>  14
>
> 300104
>
>  104
>
>520901
>
>  20901
>
> 520902
>
>  20902
>
> 500450
>
>  450
>
> 500451
>
>  451
>
>203529
>
>  3529
>
> 203538
>
>  3538
>
>8515959
>
>  15959
>
> 8516271
>
>  16271
>
>8203892
>
>  3892
>
> 8203893
>
>  3893
>
>1620224
>
>  224
>
> 1620225
>
>  225
>
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Regards
Rajan verma
+91 9158998701

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Puttu *
Can you please please help any one

On Fri, Apr 1, 2011 at 5:40 PM, Puttu *  wrote:

> sorry again, please hep me in the formula
>
>
> On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:
>
>> awaiting for your replay please.
>>
>>
>> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>>
>>> Experts please help me on this it's bit urgent sorry to bother.
>>>
>>>
>>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>>>
 Hi Experts,

 I have list of items which have not full codes. I need them to convert
 full code. Could you please help me.

 Item code column has either 3, 2, 4 & 5 digits no. but by default they
 should be either 6 or 7 or 8 digits code. What best formul I need to use to
 get that output. Item Full Code output column has the correct answers
 which I manually entered. I want the same way answer using the formulas


 Item Full Code output

 Give the formula for output

 Item Code

 200990

  990

 200991

  991

300011

  11

 300014

  14

 300104

  104

520901

  20901

 520902

  20902

 500450

  450

 500451

  451

203529

  3529

 203538

  3538

8515959

  15959

 8516271

  16271

8203892

  3892

 8203893

  3893

1620224

  224

 1620225

  225


 --
 Putta

 --

 --
 Some important links for excel users:
 1. Follow us on TWITTER for tips tricks and links :
 http://twitter.com/exceldailytip
 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
 3. Excel tutorials at http://www.excel-macros.blogspot.com
 4. Learn VBA Macros at http://www.quickvba.blogspot.com
 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 To post to this group, send email to excel-macros@googlegroups.com

 <><><><><><><><><><><><><><><><><><><><><><>
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel

>>>
>>>
>>>
>>> --
>>> Putta
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread sunny k
why r u using 200 for 990 or 300 for 11 any reason

On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:

> Experts please help me on this it's bit urgent sorry to bother.
>
>
> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I have list of items which have not full codes. I need them to convert
>> full code. Could you please help me.
>>
>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>> get that output. Item Full Code output column has the correct answers
>> which I manually entered. I want the same way answer using the formulas
>>
>>
>> Item Full Code output
>>
>> Give the formula for output
>>
>> Item Code
>>
>> 200990
>>
>>  990
>>
>> 200991
>>
>>  991
>>
>>300011
>>
>>  11
>>
>> 300014
>>
>>  14
>>
>> 300104
>>
>>  104
>>
>>520901
>>
>>  20901
>>
>> 520902
>>
>>  20902
>>
>> 500450
>>
>>  450
>>
>> 500451
>>
>>  451
>>
>>203529
>>
>>  3529
>>
>> 203538
>>
>>  3538
>>
>>8515959
>>
>>  15959
>>
>> 8516271
>>
>>  16271
>>
>>8203892
>>
>>  3892
>>
>> 8203893
>>
>>  3893
>>
>>1620224
>>
>>  224
>>
>> 1620225
>>
>>  225
>>
>>
>> --
>> Putta
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Umesh Dev
Hi Puttu,

explain it in excel sheet and also mention all the possibilities.

Regards
Umesh

On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:

> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
>>
>>
>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have list of items which have not full codes. I need them to convert
>>> full code. Could you please help me.
>>>
>>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>>> get that output. Item Full Code output column has the correct answers
>>> which I manually entered. I want the same way answer using the formulas
>>>
>>>
>>> Item Full Code output
>>>
>>> Give the formula for output
>>>
>>> Item Code
>>>
>>> 200990
>>>
>>>  990
>>>
>>> 200991
>>>
>>>  991
>>>
>>>300011
>>>
>>>  11
>>>
>>> 300014
>>>
>>>  14
>>>
>>> 300104
>>>
>>>  104
>>>
>>>520901
>>>
>>>  20901
>>>
>>> 520902
>>>
>>>  20902
>>>
>>> 500450
>>>
>>>  450
>>>
>>> 500451
>>>
>>>  451
>>>
>>>203529
>>>
>>>  3529
>>>
>>> 203538
>>>
>>>  3538
>>>
>>>8515959
>>>
>>>  15959
>>>
>>> 8516271
>>>
>>>  16271
>>>
>>>8203892
>>>
>>>  3892
>>>
>>> 8203893
>>>
>>>  3893
>>>
>>>1620224
>>>
>>>  224
>>>
>>> 1620225
>>>
>>>  225
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Bhushan Sabbani
attach the sample file so we can help you.


-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Puttu *
sorry again, please hep me in the formula

On Fri, Apr 1, 2011 at 5:12 PM, Puttu *  wrote:

> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
>>
>>
>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>>
>>> Hi Experts,
>>>
>>> I have list of items which have not full codes. I need them to convert
>>> full code. Could you please help me.
>>>
>>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>>> get that output. Item Full Code output column has the correct answers
>>> which I manually entered. I want the same way answer using the formulas
>>>
>>>
>>> Item Full Code output
>>>
>>> Give the formula for output
>>>
>>> Item Code
>>>
>>> 200990
>>>
>>>  990
>>>
>>> 200991
>>>
>>>  991
>>>
>>>300011
>>>
>>>  11
>>>
>>> 300014
>>>
>>>  14
>>>
>>> 300104
>>>
>>>  104
>>>
>>>520901
>>>
>>>  20901
>>>
>>> 520902
>>>
>>>  20902
>>>
>>> 500450
>>>
>>>  450
>>>
>>> 500451
>>>
>>>  451
>>>
>>>203529
>>>
>>>  3529
>>>
>>> 203538
>>>
>>>  3538
>>>
>>>8515959
>>>
>>>  15959
>>>
>>> 8516271
>>>
>>>  16271
>>>
>>>8203892
>>>
>>>  3892
>>>
>>> 8203893
>>>
>>>  3893
>>>
>>>1620224
>>>
>>>  224
>>>
>>> 1620225
>>>
>>>  225
>>>
>>>
>>> --
>>> Putta
>>>
>>> --
>>>
>>> --
>>> Some important links for excel users:
>>> 1. Follow us on TWITTER for tips tricks and links :
>>> http://twitter.com/exceldailytip
>>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>>
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> <><><><><><><><><><><><><><><><><><><><><><>
>>> Like our page on facebook , Just follow below link
>>> http://www.facebook.com/discussexcel
>>>
>>
>>
>>
>> --
>> Putta
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Puttu *
awaiting for your replay please.

On Fri, Apr 1, 2011 at 4:49 PM, Puttu *  wrote:

> Experts please help me on this it's bit urgent sorry to bother.
>
>
> On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:
>
>> Hi Experts,
>>
>> I have list of items which have not full codes. I need them to convert
>> full code. Could you please help me.
>>
>> Item code column has either 3, 2, 4 & 5 digits no. but by default they
>> should be either 6 or 7 or 8 digits code. What best formul I need to use to
>> get that output. Item Full Code output column has the correct answers
>> which I manually entered. I want the same way answer using the formulas
>>
>>
>> Item Full Code output
>>
>> Give the formula for output
>>
>> Item Code
>>
>> 200990
>>
>>  990
>>
>> 200991
>>
>>  991
>>
>>300011
>>
>>  11
>>
>> 300014
>>
>>  14
>>
>> 300104
>>
>>  104
>>
>>520901
>>
>>  20901
>>
>> 520902
>>
>>  20902
>>
>> 500450
>>
>>  450
>>
>> 500451
>>
>>  451
>>
>>203529
>>
>>  3529
>>
>> 203538
>>
>>  3538
>>
>>8515959
>>
>>  15959
>>
>> 8516271
>>
>>  16271
>>
>>8203892
>>
>>  3892
>>
>> 8203893
>>
>>  3893
>>
>>1620224
>>
>>  224
>>
>> 1620225
>>
>>  225
>>
>>
>> --
>> Putta
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>
>
>
> --
> Putta
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


Re: $$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Puttu *
Experts please help me on this it's bit urgent sorry to bother.

On Fri, Apr 1, 2011 at 4:10 PM, Puttu *  wrote:

> Hi Experts,
>
> I have list of items which have not full codes. I need them to convert full
> code. Could you please help me.
>
> Item code column has either 3, 2, 4 & 5 digits no. but by default they
> should be either 6 or 7 or 8 digits code. What best formul I need to use to
> get that output. Item Full Code output column has the correct answers
> which I manually entered. I want the same way answer using the formulas
>
>
> Item Full Code output
>
> Give the formula for output
>
> Item Code
>
> 200990
>
>  990
>
> 200991
>
>  991
>
>300011
>
>  11
>
> 300014
>
>  14
>
> 300104
>
>  104
>
>520901
>
>  20901
>
> 520902
>
>  20902
>
> 500450
>
>  450
>
> 500451
>
>  451
>
>203529
>
>  3529
>
> 203538
>
>  3538
>
>8515959
>
>  15959
>
> 8516271
>
>  16271
>
>8203892
>
>  3892
>
> 8203893
>
>  3893
>
>1620224
>
>  224
>
> 1620225
>
>  225
>
>
> --
> Putta
>
> --
>
> --
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/discussexcel
>



-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel


$$Excel-Macros$$ Urgent Formula Required Help me

2011-04-01 Thread Puttu *
Hi Experts,

I have list of items which have not full codes. I need them to convert full
code. Could you please help me.

Item code column has either 3, 2, 4 & 5 digits no. but by default they
should be either 6 or 7 or 8 digits code. What best formul I need to use to
get that output. Item Full Code output column has the correct answers
which I manually entered. I want the same way answer using the formulas


Item Full Code output

Give the formula for output

Item Code

200990

 990

200991

 991

   300011

 11

300014

 14

300104

 104

   520901

 20901

520902

 20902

500450

 450

500451

 451

   203529

 3529

203538

 3538

   8515959

 15959

8516271

 16271

   8203892

 3892

8203893

 3893

   1620224

 224

1620225

 225


-- 
Putta

-- 
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links : 
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 
To post to this group, send email to excel-macros@googlegroups.com

<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel