|
|
#1
06-04-2017, 07:15 AM
|
|||
|
|||
Move text to another cell
I have several blocks of text like this...
A1: coffee A2: creamer A4: straws A5: cups ...I need to be able to move each second row of text to the cell one row above and one column right of it and remove the empty rows between so that it looks like this... A1: coffee B1: creamer A2: straws B2: cups Is there a macro that can help me do this through the whole spreadsheet? Thanks Last edited by ewso; 06-04-2017 at 04:04 PM. 
|
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| extract time from a cell and move it to front of cell before text | ewso | Excel | 20 | 03-19-2017 11:34 AM |
| Move the data at bottom cell to right side of the cell | kcyag91 | Excel | 1 | 01-28-2016 12:28 AM |
 Macro to move focus after entry in a cell
|
Phil H | Excel Programming | 3 | 06-18-2015 01:20 PM |
| Move data from 1 cell to another cell | Catalin.B | Excel | 1 | 06-25-2011 12:51 PM |
| Auto-populate an MS Word table cell with text from a diff cell? | dreamrthts | Word Tables | 0 | 03-20-2009 01:49 PM |
Windows 10 
Office 2016
Threaded Mode