Thank you, Norman.
You're cool! As per the reply directly before yours, it was extremely
helpful. Unfortunately, yours is more versatile because it takes me to and
through steps that make me lean a lot more than I wanted. BOth helpful,
yours more so, and thank youy very much.

Also,
HAPPY HOLIDAYS
Rick Denessen

"Norman Jones" wrote:

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?