Thank you very much! After 3 months or so, seems like more, I finally get a
straight answer. Now I can get on with my projects and straighten out some
books.
Thanks again.,
and,
HAPPY HOLIDAYS!
"tjtjjtjt" wrote:
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?
|