Concatenate function is not working. Function Builder indicates the result I am looking for but the cell containing the function is displaying the formula and not the result. I have formatted all of the effected cells as "General." The calculation preference is set at "Automatically." Many thanks.