Question: how to copy same value in multiple cells in excel formula?
Answer: Select all the blank cells in a column.
Press F2 to edit the last selected cell and type some data: it can be text, a number, or a formula (e.g. "_unknown_")
Press Ctrl+Enter instead of Enter. All the selected cells will be filled with the data that you typed.