sorry again, please hep me in the formula

On Fri, Apr 1, 2011 at 5:12 PM, Puttu * <puttu...@gmail.com> wrote:

> awaiting for your replay please.
>
>
> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * <puttu...@gmail.com> wrote:
>
>> Experts please help me on this it's bit urgent sorry to bother.
>>
>>
>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * <puttu...@gmail.com> 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

Reply via email to