auto fill the blank with value

[Guest]

how can i auto fill the blankcell with a value till the next blank..den auto
fill again with another values..mean in this case i wan the value "A" to fill
up all the blank cell below it and stop on top of the value"B" den auto fill
with "b" values to nxt blank n cont...

eg..

col a col b
A 1
2
3
B 2
3
C 4

 

[Guest]

Say your list is from A2 to A100 with some values and some blanks.
First highlight the range a2 to A100
Then Edit/Goto/Special blanks.
Then enter the following formula
=if(A1<>A2,A2,A1) and hit control-Enter
(Control Enter merely fills the formula in all selected cells)