Hi confused,

There are many ways of doing this. Here's one:
For the 1st number:
=MID(A1,FIND("(",A1)+1,FIND(")",A1)-FIND("(",A1)-1)
For the 2nd number:
=MID(A1,FIND(",",A1)+3,FIND(")",MID(A1,FIND(",",A1 )+3,LEN(A1)))-1)
For the 3rd number:
=MID(A1,FIND("(",A1,FIND("(",A1,FIND("(",A1)+1)+1) +1,LEN(A1)-FIND("(",A1,FIND("(",A1,FIND("(",A1)+1)+1)-1)

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

"Confused" wrote in message ...
How do I break this string of letters without having to manually enter this
into three columns? L(117),D(90),O(4)

The end result should be in three separate columns (117, 90, 4).