How to keep "1:1" as text
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 起初，神創造天地。" 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.
|