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

is there a formula that I can use?

"john" wrote:

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)


"Confused" wrote:

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

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