I have three columns of data B1, C1, D1 which I concatenate into a fourth
column E1. Then I need to use the autofill function in the fourth column do
autofill the formula on all rows below the initial cells.

What is happening is that on each subsequent row, it is actually copying the
data in cell E1 down through each cell. However, when I click on one of the
cells and look in the formula bar, the formula is correct but the resulting
data is not.

Am I doing something here?