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