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 *" wrote:
> Can you please please help any one
>
>
>
>
>
> On Fri, Apr 1, 2011 at 5:40 PM, Puttu * wrote:
> > sorry again, please hep me in the formula
>
> > On Fri, Apr 1, 2011 at 5:12 PM, Puttu * wrote:
>
> >> awaiting for your replay please.
>
> >> On Fri, Apr 1, 2011 at 4:49 PM, Puttu * wrote:
>
> >>> Experts please help me on this it's bit urgent sorry to bother.
>
> >>> On Fri, Apr 1, 2011 at 4:10 PM, Puttu * 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