Find Square Inch Of A Cell

[LUIS CORDERO]

HELLO, NEED SOME HELP,
IF IN CELL A1 IS THE SIZE 52X52 HOW CAN I GET B2 TO = THE SQUARE INCH
OF THAT SIZE
EXAMPLE 42X42 WILL EQUAL 1764 OR 62X62 WILL EQUAL 3844
ALL DONE BY HAND RIGHT NOW
I LOVE THIS SITE AND ALL THE GREAT PEOPLE THAT ARE HERE TO HELP

MUCHO THANKS

 

[Peo Sjoblom]

Please turn off the caps lock, it is considered shouting

=LEFT(A1,SEARCH("x",A1)-1)*MID(A1,SEARCH("x",A1)+1,255)