Can you please please help any one On Fri, Apr 1, 2011 at 5:40 PM, Puttu * <puttu...@gmail.com> wrote:
> 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 > -- 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
