google sheet how to variable in cell and text code example

Example: get cell value from string google sheets

=CONCAT("value is ", C5)