google sheets get current sheet cell value code example

Example: get cell value from string google sheets

=CONCAT("value is ", C5)