to fill number in google sheets code example

Example 1: number of filled cells google sheets

=SUMPRODUCT(LEN(TRIM(A2:A13))>0)

Example 2: get cell value from string google sheets

=CONCAT("value is ", C5)