Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Is it possible to -
1. Re-arrange values in a single cell into numerical order within the cell? - to explain - cell A1 looks like 25 4 11 29 16 - how do I make it look like - 4 11 16 25 29 2. Copy each of a number of values in a single cell to it's own cell? - to explain, using the above example - cell B1 would end up with the value 25, B2 would have 4, B3 would have 11, and so on I'm sure this can be done through a VB scripts and thus a macros, but I don't have quite enough knowledge to write them |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Moving Cell Values | Excel Discussion (Misc queries) | |||
moving values only | Excel Discussion (Misc queries) | |||
moving x column values into x row values | Excel Worksheet Functions | |||
moving values from sheet to another | Excel Discussion (Misc queries) | |||
moving values from one sheet to another | Excel Discussion (Misc queries) |