| 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 |
| 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 | |||
Threaded Mode
