Multiplying two numbers in a cell

[Tysaroni]

I know this might seem simple but I am a novice in Excel. I have a cell (C5) that reads as follows:

8.5” x 25.75”

How do I multiply these numbers and get that quantity into cell H5?

Thank you!

 

[ISY]

Hi

=PRODUCT(INDEX(--TEXTSPLIT(C5,"""","x"),,1))

 

[hrayani]

How about

=VALUE(LEFT(C5, SEARCH("”", C5) - 1)) * VALUE(MID(C5, SEARCH("x", C5) + 2, SEARCH("”", C5, SEARCH("x", C5)) - SEARCH("x", C5) - 2))

 

[Tysaroni]

Hi

=PRODUCT(INDEX(--TEXTSPLIT(C5,"""","x"),,1))

Thank you. This works.

 

[Fluff]

@Tysaroni In future please mark the post that contains the solution, rather than your post saying it works. I have changed it for you. Thanks

 

[Rick Rothstein]

Hi

=PRODUCT(INDEX(--TEXTSPLIT(C5,"""","x"),,1))

WIthout the INDEX function...

=PRODUCT(--TEXTSPLIT(A1,{" ","x",""""},,1))

 

[Peter_SSs]

.. or probably even

=PRODUCT(-TEXTSPLIT(C5,{" ","x",""""},,1))

 

[Scott Huish]

Trying to learn something from this, but I couldn't get any of those solutions to work.

Book2
	C	D	E	F
5	8.5” x 25.75”	#VALUE!	#VALUE!	#VALUE!
Sheet1

Cell Formulas
Range	Formula
D5	D5	=PRODUCT(INDEX(--TEXTSPLIT(C5,"""","x"),,1))
E5	E5	=PRODUCT(--TEXTSPLIT(C5,{" ","x",""""},,1))
F5	F5	=PRODUCT(-TEXTSPLIT(C5,{" ","x",""""},,1))

 

[Scott Huish]

Never mind, it's the smart quotes when copying the value from this page.