I’d like to be able to convert a cell with text into a formula.
Sorry, but your question is not entirely clear. What exactly is the text in a cell? What result should return a formula?
I’m going to take a guess at what you are trying to do. Does this help? ="this is column number "&COLUMN()