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.

--
Biff
Microsoft Excel MVP


"LiCal" wrote in message
...
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.

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.
--
David Biddulph

"LiCal" wrote in message
...
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?