Fill down using Find/Select blanks then concatenate columns

[CiaoKarina]

Hello...I'm sure this is an easy one...

I am using the Find/Select > Goto Special > Blanks to carry down values in empty cells in columns A and B. Then I want to concatenate columns A and B into column C but since the originally empty cells are a formula, the concatenate is not working, it is not looking at the actual text that results. I cannot Concatenate first, then fill down because the "empty" cells in my concatenated column C are not blank, its just concatenating blank cells.

 

[Joe4]

It typically, it does not matter if a cell is hard-coded or populated by formulas. Other formulas that access those cells run off the value that is returned in the cell.
Are you sure that you have the calculation mode set to Automatic?

If you still are having issues, post an example, and your formula for us to look at.

 

[CiaoKarina]

I formatted the resulting cells to "general" and it worked!