Excel's INDIRECT function turns a text ... This is particularly handy if you're creating a reference to another sheet, as it helps you avoid having to remember the exclamation point in the syntax.