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

-- 
----------------------------------------------------------------------------------
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