convert text string to cell reference

[Andrew]

is there any way of converting a text string to a cell reference?

 

[Peo Sjoblom]

Yes,

look at indirect in help