Hi,

Am Thu, 4 Jul 2013 14:02:22 +0100 schrieb lizexcel:

Is it possible to use an Excel function to copy text spanning a random
number of blank rows, as shown below? (* used for spacing and to
indicate blank rows)

Col A*****Desired Column B
Apple*****Apple
*********Apple
*********Apple
Banana***Banana
*********Banana
Carrot****Carrot
Damson***Damson
*********Damson
*********Damson
*********Damson
*********Damson

in B2 try:
=A2
in B3 try:
=IF(A3="",B2,A3)
and copy down.


Regards
Claus B.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2