Try Data Text to Columns Comma delimited.
Then do an Edit Replace "*(" with "(" and change the sign.


On 9 Mar, 05:34, Confused wrote:
In my worksheet, I have a series of strings that contain text, numbers and ().

For example,
In cell A1, string of text L(117),D(93),O(5).
In cell A2, string of text L(6),D(117),O(20)
In cell A3, string of text GRTR1%orYM(119),O(3).

The end result for each cell would be:

Column 1 Column 2 Column 3
Column 4
Result from Cell A1 117 93 5
Result from Cell A2 6 117 20
Result from Cell A3 3
119

Can anyone help me with a formula that produces the above results?
Any help is much appreciated !!