Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Split list via every other cell.
Okay. I had someone show me what to do (on office 2003 I think) but I cannot
get it to work on 2007. I have a list I am trying to split with every other number, odd and even. The list in column A is about 460 words. In column B, I was shown to do this.... cell B1 =$A1 cell B2 =$A3 He then used the CTRL key to select both cells and then drag down. What this did was a continuation of the odd numbers but let A appear before each number. When I use the CTRL key in Office 2007 and select both cells, I do not get the dark outline with the black dot at the bottom right that is supposed to be used from grabbing and dragging. I have alos tried the shift key which seems to select both but when dragging down does not do what this person had shown me. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
List Sorted/Split into groups | Excel Worksheet Functions | |||
split email id list into 1 extra list with everything after "@" | Excel Worksheet Functions | |||
split a cell diagonally in excell - a calendar -2 dates in 1 cell | Excel Discussion (Misc queries) | |||
How can I split one cell into two cell parts (upper & lower)? | Excel Discussion (Misc queries) | |||
How do I split a list by every other one in excel? | Excel Discussion (Misc queries) |