Your data is not very consistent - you have some asterisks and some phone numbers in that column.

Anyway, highlight the cells from A4 to A243, then press F5 (GoTo) and click on Special then on Blanks. Then begin to enter a formula by typing =, then click on the cell immediately above the active cell (i.e. on A6 in your example) and then CTRL-Enter together. This will automatically copy that formula down into the blank cells.

Hope this helps.

Pete