Pinned Loading

1. Alternative for SUBSTITUTE Excel For... Alternative for SUBSTITUTE Excel Formula, very similar to programming languages text interporlation. Replaces any matching {{HEADER_CELL}} with the value.

   1

   Function MAGIC_REPLACE(TEXT As String, MATRIX As Range, REFERENCE_ROW As Integer) As String

   2

       ' This snippet acts in a similar way to text interpolation in programming languages, which works as follows:

   3

       ' it reads the text initially and looks to see if there is any text inside the double braces (which is the interpolation), 

   4

       ' if it finds any in the table, it will replace it with the value of the line below in general. 

   5

       Dim Header As Range