| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
Perfect, thank you!
|
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy several row headers to rows (blank) below for each header | Excel Discussion (Misc queries) | |||
| Copy non blank rows only | Excel Programming | |||
| Text to Rows and then Insert Blank Rows | Excel Discussion (Misc queries) | |||
| Copy rows of data (eliminating blank rows) from fixed layout | Excel Discussion (Misc queries) | |||
| Copy rows, but exclude blank rows | Excel Programming | |||
Linear Mode
