How to keep "1:1" as text

L

LiCal

I want to split the text between " : "1:1 $B5/=i!$?@AOB$E7CO!#(B" into 2
columns (data - text to columns) at the first SPACE

How to format "1:1" to remain as text and not be treated as HH:MM
etc.
 
T

T. Valko

In Step 3 of the Text to Columns wizard, in the Data Preview area, click on
the area where it shows 1:1. In Column data format select Text. Then click
Finish.
 
L

LiCal

Thanks. But is this the only way?

why setting column 1 (after split, to have 1:1) to text (Format->
Cells->Text) prior and after the split operation has no effect?
 
D

David Biddulph

If you treat it as a number (not text) at the input stage, then changing the
format to text later will merely display the stored number as text. Times
are numbers (as fractions of a day).
If you have stored 1:1 as time 01:01, it will be displayed as 0.042361111 if
you change it to text.
 
Top