Forum Discussion
Solved
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...
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.
KimLabenz365 You can also apply an IF function that can fill in the gaps as a helper column. Once you have the final result, just replace the original column as a text of the solution -- see example attached.