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
>
>Item Full Code output
>
> Give the formula for output
>
> Item Code
>
> 200990
> =Text(item_Code,"000")
>
> 990
>
> 200991
>
> 991
>
>300011
>
> 11
>
> 300014
>
> 14
>
> 300104
>
> 104
>
>520901
>
> 20901
>
> 520902
>
> 20902
>
> 500450
>
> 450
>
> 500451
>
> 451
>
>
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
why r u using 200 for 990 or 300 for 11 any reason
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
Hi Puttu,
explain it in excel sheet and also mention all the possibilities.
Regards
Umesh
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.
attach the sample file so we can help you.
--
--
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.lin
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 *
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
>>
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. bu
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 Cod
10 matches
Mail list logo