| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
moving cells
I have a spreadsheet with 1500 entries in one column A. Each entry consist
of 4 lines of data and a space. I need to move the 2nd, 3rd and 4th lines to columns b,c,d. and to delete the space between entries. example: John Doe 1234 lost street Chicago, IL 60055 555-555-1212 Jane Doe 4321 Lost Street Chicago, IL 60055 555-555-1212 changed to: John Doe 1234 lost street Chicago, IL 60055 555-555-1212 Jane Doe 4321 lost street Chicago, IL 60055 555-555-1212 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Moving text around cells without moving boarder lines | Excel Discussion (Misc queries) | |||
| Enter Key + Dragging Cells / Moving Cells | Excel Discussion (Misc queries) | |||
| Arrow Keys Moving Window Frame instead of Moving Between Cells | Excel Discussion (Misc queries) | |||
| Moving some cells. | Excel Programming | |||
| Cells(col,row) keep moving to lower case and I can not ref. a cells in a differnet sheet | Excel Programming | |||
Threaded Mode
