left sum

[Utsav]

Hi dear,

I have got two values
like this 63/59 innone cell and 18/11 in other cell.I want to add left values and right values ,I have done this using left function

=LEFT(C9,2)+LEFT(J9,2)

but the problem is some time the values is in single digit , then the formula stops working bcoz of this "/".

jus help me ...

Utsav

 

[Jon von der Heyden]

Hi

Try: =LEFT(C9,FIND("/",C9)-1)+LEFT(J9,FIND("/",J9)-1)

Regards
Jon

 

[Richard Schollar]

Hi Utsav

You could use:

=LEFT(C9,FIND("/",C9&"/")-1)+LEFT(J9,FIND("/",J9&"/")-1)

 

[mortgageman]

Hi dear,

I have got two values
like this 63/59 innone cell and 18/11 in other cell.I want to add left values and right values ,I have done this using left function

=LEFT(C9,2)+LEFT(J9,2)

but the problem is some time the values is in single digit , then the formula stops working bcoz of this "/".

jus help me ...

Utsav

I'm not pretending to have an answer here, but I do have a (meaningful) question: Is there ever a time when only one of your two numbers will be a single digit. And for those times, does the single digit count as a "left" or a "right" (Ok that was 2 questions )

 

[Utsav]

thanks to all ...
it works


Regards

Utsav

 

[Utsav]

one thing more can u plz tell me how to extarct this
I got 3000dr
5000cr

I want to extract the dights without "cr" and "dr"...

its urgent .

Reg.
Utsav

 

[SteveO59L]

Are the last two characters always "cr" or "dr" ?

 

[Utsav]

yes

 

[SteveO59L]

=LEFT(G11,LEN(G11)-2)

 

[Utsav]

THATS DONE !!!!
thanks a lot,, but if I say I want to extract only the digits not the alpahabets and vice versa ,,, how this will be done ...

this is just for knowledge I m asking.. plz don't mind...

Regards
Utsav