Try this:

1. Highlight cell A1
2. Go to Data - Text to Columns
3. Select Delimited then Next
4. Select Space as the Delimiter then Next
5. Finish

See if that works.


" wrote:

I have a cell containing for example:

Cell A1: -7 / +18 (%)
Cell A2: -4.5 / +3.5 (pts)

I want to break out the two values into separate cells, for example:
Cell A2 = -7, Cell B2 = 18
Cell A3 = -4.5, Cell B3 = 3.5

Can someone please tell me how?

Regards,

S