Copy text into blank rows

[lizexcel]

Hello,

This is my first post here, I decided to sign up as I have a problem an
the answers on here are usually good!

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

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

et

 

[Claus Busch]

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.

 

[lizexcel]

Perfect, thank you