Multiple data in one cell

[sandeep11227]

If for example :

A1 contains 31 x 41"
i want the result in b1
how will u calculate the data in a1
whats the formula

" symbol stands for inches

[popipipo]

=left(a1,2)*mid(a1,6,2)

[sandeep11227]

Many thanks for your prompt reply......

Could you please define it a bit clearly......

I did not understand the formula if a1 contains 31 x 41" i want the result as 31x41 = 1271 in b1

[AndyLitch]

A1 : 31
B1 : 41
c1 : =A1*B1

.......... but because you are mixing text and numbers you need :-
=TRIM(LEFT(A1,FIND("x",A1,1)-1)) * MID(A1,B1+1,FIND("""",A1,1)-FIND("x",A1,1)-1)

[popipipo]

=left(a1,2) gives a result of 31
=mid(a1,6,2) gives a result of 41
31*41=1271

[sandeep11227]

If i write 31*41 in a1 calculate this in b1

[popipipo]

=TRIM(LEFT(A1,FIND("x",A1,1)-1)) * MID(A1,B1+1,FIND("""",A1,1)-FIND("x",A1,1)-1)
or ??
=(LEFT(A1,FIND("x",A1,1)-1))*MID(A1,FIND("x",A1,1)+2,FIND("""",A1)-(FIND("x",A1,1)+2))

[popipipo]

Please Login or Register  to view this content.

A1 contains 31 x 41"
..
..
" symbol stands for inches

Now you change the question!
is it now with or without ""

[sandeep11227]

it is with " symbol only sir

[popipipo]

Look here my solution of #2 and #7

[sandeep11227]

Its working thank you

how to calculate this
if a1 contains quantity 190p + 180s
and b1 contains weight 18.38

i want the result in c1 as total weight

for say weight of one packet is 18.38, what is the weight for 190 packets + 180 balance sheets

[popipipo]

"Play" with the 'find' formula to locate the different letters in a cell

[sandeep11227]

Pls give me the example

[sandeep11227]

It is not working with datas containing 31.5 x 41.5" decimals

[popipipo]

I hope this wil explane the formula.

[sandeep11227]

sir can i have ur email id i want to send the screen shots and the calculation of paper formula as we deal wid paper industry

if the size of the paper is in CMS :

L X B X GSM / 1,00,000 = ( ANSWER ) * NO OF SHEETS PER PKT

IE, BY DEFAULT WE GET WEIGHT FOR 100 SHEETS IF IT IS 250 SHEETS PER PKT WE MULTIPLY 2.5 WITH W=THE ANSWER

if the size of the is in INCHES :

L X B X GSM / 15,500 = ( ANSWER ) * NO OF SHEETS PER PKT

[sandeep11227]

can u send me some simple example for the last file u have sent as an attachment

or can i have ur email id to send the exact file of my requirement

[sandeep11227]

Attach is the file for your reference of our working......

Like said before in the last mail of our calculation and formulas

[sandeep11227]

how to convert the entire sheets to upper case in excel 2007