What is the best approach to achieve the following:
If a cell in column A has content, then place a formula into the cell in column B in the same row, referencing the cell in column A.
Once the formula has been processed, replace the formula with the raw value that the formula returned.