Hi Ricky,

With the text cells selected, try:

Data | Text to Columns | Check Delimited | Next
| Check the 'Other' option with a colon | Next |
Check Text | Click second column | Check Text | Finish

---
Regards,
Norman



"RickyDee" wrote in message
...
Here's 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?