Highlight the entire section where you want to fill in the values.
Hit F5 | Special... | Blanks (optons button)
All of the blanks to be filled in should now be highlited
Type = and the hit the up arrow
Hit Ctrl + <Enter
All of the blanks should now be filled in
copy the entire section and Paste Special values to overwrite the formulas
with the text.
--
HTH...

Jim Thomlinson


"rciolkosz" wrote:

When I export out of our company system to excel I need to copy down empty
cells. Example is:

Collingswood 418 Main St
215 Main St
564 Main St
Laurel 234 Pine St
456 Pine St

How do I formulate "Collingswood" to copy down and then "Laurel" and so on?