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 *" <puttu...@gmail.com> wrote: > 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 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
