First, I would try Data | Text to Columns and use the colon as the Delimiter.
Barring that, you can try these (this eample assumes the original text is in
A3--
To get the data before the colon:
=LEFT(A3,FIND(":",A3,1)-1)
To get the data after the colon:
=MID(A3,FIND(":",A3)+1,LEN(A3))
tj
"RickyDee" wrote:
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?
|