Breaking a string of letters
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).
|