hi, ak !

How can the text in one cell convert into formula?
For example, this is the text in Cells(1,1) :-
18.5x20x15
instead of using the INSTR to find each "x" , any other method?
thanks for the help in advance

i.e.: - cells(1,1)="="&replace(cells(1,1),"x","*")

or, if you need for excel 97: - cells(1,1)="="&application.substitute(cells(1,1)," x","*")

hth,
hector.