Probably something simple

[Kent]

I have a text cell that reads 24x36, it could read 30x42
etc, but always in that format #x#. I want to have that
cell multiply and give me the value. I have used replace
to change the x to a * but lost after that point.

Kent

 

[Bernard V Liengme]

Hi Kent,
You need = in front to tell Excel it is a formula (unlike Lotus 1-2-3 !)
=24*36
Bernard

 

[Don Guillett]

try this. Modify to suit your needs

Sub makeformula()
For Each c In [h11:h15]
c.Value = "=" & Application.Substitute(c, "x", "*")
Next
End Sub

 

[Fred Smith]

Or, forget the Replace, and use a formula like:

=LEFT(A1,2)*RIGHT(A1,2)