google sheets return cell number code example

Example: get cell value from string google sheets

=CONCAT("value is ", C5)