Copy text into blank rows
Hello,
This is my first post here, I decided to sign up as I have a problem and the answers on here are usually good! 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 More text*More text *********More text etc |
Copy text into blank rows
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 |
Perfect, thank you!
|
All times are GMT +1. The time now is 01:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com