How to keep "1:1" as text

  • Thread starter Thread starter LiCal
  • Start date Start date
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.
 
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.
 
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?
 
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.
 
Back
Top