Raj,

What are the number pairs separated by? In your post it appears to be
multiple spaces.

Where is the output to appear relative to the cell containing the original
string? For example, should the current cell with the string be the upper
left cell of the range created?

Is it always going to be four number pairs and an odd lone number or might
there be more pairs?


Steve Yandl



"Raj" wrote in message
...
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