Probably something simple

  • Thread starter Thread starter Kent
  • Start date Start date
K

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
 
Hi Kent,
You need = in front to tell Excel it is a formula (unlike Lotus 1-2-3 !)
=24*36
Bernard
 
try this. Modify to suit your needs

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