Splitting text in one column into two (or more) columns.
Heres the problem
I have one column formatted as TEXT. This column (called PRERESULT)
contains numbers as follows:
86:56 but can contain three numbers on each side of the : (Colon). I have
three columns:
PRERESULT, RESULT1, RESULT2
I want to take apart PRERUSULT and put the numbers preceding the : in
RESULT1 and the numbers after the : in RESULT2.
Remember, all information is TEXT.
HOW?
|