Multiply String "x" and number

[diyVBA]

A2 12x12x12
A3 12X13X12
A4 12X18X21

I want to multiply it, the character X is creating issue.
How can I multiply these?

[popipipo]

Please Login or Register  to view this content.

Maybe this?

[Paul]

Popipipo's solution would work fine if all cells contained three two-digit numbers separated by x's. If that's not the case, it will likely be easier to use VBA, specifically the Evaluate function. The good news is that using this method you can also do addition, subtraction and division (assuming you use the +, - and / characters). You could even convert this to a function to use as a formula in your spreadsheet rather than having to run a macro anytime your column A values change.

Please Login or Register  to view this content.

[MarvinP]

Hi diy,

I saw this YouTube video a few weeks ago that gave me a hint for this magic answer at:
https://www.bing.com/videos/search?q...5&&FORM=VDRVRV

What it showed is that you can use the VBA "Evaluate" function in the Names Manager.
In the Names Manager I used "=EVALUATE(SUBSTITUTE(Sheet1!A2,"x","*"))" when in B2.
Now in B3 simply type "=Eval" and boom the answer appears. Magic??

See the attached
Evaluate in Named Range.xlsm

[jeffreybrown]

You could also use...

Please Login or Register  to view this content.

Then in B2 >> =nSum(A2)

[diyVBA]

Yes, you are right Paul.

[Paul]

Wrong thread, diyVBA? This is an older one of yours that doesn't seem to relate.