PDA

View Full Version : I have an excell database of 10000 entries. how do i fill in the blanks on 1 column?


drdreallday
10-09-2007, 11:27 PM
on one column, half the entries are missing, so i want to fill in the blanks with a plug of some sort. how do i do this without having to copy and paste 5000 times!!!
acierinox- tried this mate, unfortunately the blanks are intermitant, and this just pastes over everything.
ok sorted: i've data sorted the database using the column thats half full. which has put all blank boxes next to each other. and then copied and pasted.