Hi

I have a cells with a value similar to
1.2.3
And I have some code to turn it into a formula.
=CONCATENATE("=",REPLACE(REPLACE(A2,FIND(".",A2,1),1,"*100+"),FIND(".",REPLACE(A2,FIND(".",A2,1),1,"*100+"),1),1,"*10+"))
which gives me: = 1*100+2*10+3
in the cell. The problem is that it doesn't calculate. I guess excel just sees it as text.
I've tried value, clean, trim...past special..Although I'd rather just have a formula that doesn't it rather then having to manually copy and past something.

Thanks