| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
copy / paste without skipping blanks
Hi,
I am trying to sort a worksheet that has all the data in one column. I need to seperate the numbers into one column and the text in another. I tried f5:Go To Special but when it pastes it skips blanks (box not checked) so nothing lines up anymore. How do I do this? Its a large file and I sure don't want to do this manually. Tia Todd |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Copy & Paste Non Blanks Only | Excel Worksheet Functions | |||
| Macro - Copy and Paste repeatedly skipping cells | Excel Discussion (Misc queries) | |||
| copy a list and skipping blanks | Excel Worksheet Functions | |||
| copy range of cells with blanks then paste without blanks | Excel Worksheet Functions | |||
| Paste Special Skip Blanks not skipping blanks, but overwriting... | Excel Discussion (Misc queries) | |||
Threaded Mode
