If your Columns are filled then you can double click on the black box in the corner of the cell with the Formula in and that will fill down.
The only other way i Lnow to fill the range would be to go to the Lastrow of your data and press <Ctrl> + <Shift> + <Up Arrow> and paste the formula in.
if you want the formula in every cell of the column just Copy the Data, Highlight the Column you want then Paste. This will fill the Column
Here's some code, by Ivan Moala, that will change text in the Used Range and give you options as to how to convert it. (Lower, Upper, Proper, Sentence).
'code by Ivan F. Moala
Dim ocell As Range, ans As String
ans = Application.InputBox("Type in Letter" & vbCr & _
"(L)owercase, (U)ppercase, (S)entence, (T)itles ")
If ans = "" Then Exit Sub
For Each ocell In Selection.SpecialCells(xlCellTypeConstants, 2)
Select Case UCase(ans)
Case "L": ocell = LCase(ocell.Text)
Case "U": ocell = UCase(ocell.Text)
Case "S": ocell = UCase(Left(ocell.Text, 1)) & _
LCase(Right(ocell.Text, Len(ocell.Text) - 1))
Case "T": ocell = Application.WorksheetFunction.Proper(ocell.Text)