Breaking a string of letters

[Guest]

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).

 

[Guest]

is there a formula that I can use?

One way is to change all the ( to a , using fine & replace, then use text to
colums using ) and , as the delimiters and skip the columns you dont want.
You should have 117 90 & 4 in seperate columns

John
MOS Master Instructor Office 2000, 2002 & 2003
Please reply & rate any replies you get

Ice Hockey rules (especially the Wightlink Raiders)

 

[macropod]

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