| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to separate value into different cells?
Does anyone have any suggestions on how to separate the value into different
cells? For example, the text in cell A1 and A2 are shown below 1 CHEUNG KONG 929,000 83,737,500 3,933,462 354,652,820 196 HONGHUA GROUP 175,000 223,950 1,817,000 2,333,084 I would like to retrieve the last 4 values into 929,000 in AA1, 83,737,500 in AB1, 3,933,462 in AC1, 354,652,820 in AD1 175,000 in AA2, 223,950 in AB2, 1,817,000 in AC2, 2,333,084 in AD2 Does anyone have any suggestions on how to do it? Thanks in advance for any suggestions Eric |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Separate Cells 2 | Excel Discussion (Misc queries) | |||
| separate two dates from a text string into two separate cells | Excel Discussion (Misc queries) | |||
| Elapsed time when separate cells contain time and separate date | New Users to Excel | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
| Separate first and second name in one cell into separate cells. | Excel Discussion (Misc queries) | |||
Threaded Mode
