I want to add the same word from cell B1 to B40000

I do not want to use the click and drag box method to apply it across multiple cells/rows.

I know I have to type in the formula bar B1:B40000 but I am missing something.