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