Splitting text in one column into two (or more) columns.

[Guest]

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?

 

[Norman Jones]

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

 

[Guest]

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

 

[Guest]

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!

 

[Guest]

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