Is there a formula to auto fill down text?

I have Client names in Column A. In column B, I have various projects that take up multiple cells below. The client name is only on the line of the first project but then is blank until it gets to th...

excel

Formulas and Functions

KimLabenz365
Feb 04, 2021
HansVogelaar
So I selected the range and did as you suggested. All of the correct blank cells were highlighted. I used the formula =A6.

Now, instead of '0' appearing in all the blanks, 'A6' is what appears.

I tried the IF function in the helper column, as suggested by adversi. The same thing happened and 'A6' is what appeared as a result.

Are there any settings I need to adjust for the cells?

Thanks.