Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi,
A cell has the following string: 1-5 3-4 12-2 1-3 5 ie. pairs of numbers separated by a hyphen and an odd lone number at the end of the string This needs to be converted into columns and rows as follows: 1 5 3 4 12 2 1 3 5 Each hyphenated pair into two columns in a row and the odd lone number in a third column in the last row. Thanks in advance for the help. Regards, Raj |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
splitting a string | Excel Programming | |||
Splitting a text string into string and number | Excel Discussion (Misc queries) | |||
splitting string in 2 parts | Excel Programming | |||
Splitting a String | Excel Programming | |||
Splitting Character String | Excel Worksheet Functions |