excel convert range to 0-1 code example Example: excel convert cell value to range =INDIRECT("range") =INDIRECT(cell_with_range_as_text)