Hello,
I am importing data from an html site that uses colons to separate data (i.e. soccer results with scores 1:1, 2:2 etc) in each cell. When the import request goes through, it makes the 1:1 scores as a time of 1:01:00AM.
I am wondering how I can either get it to show plainly as '1:1' i.e. as text, or somehow transform it to show as '1-1' or even simply '1 1' so this problem wouldn't persist. I have tried the left right functions, the value function, the text function and none of those work..
Many thanks in advance!!
-tvbuddy01
I am importing data from an html site that uses colons to separate data (i.e. soccer results with scores 1:1, 2:2 etc) in each cell. When the import request goes through, it makes the 1:1 scores as a time of 1:01:00AM.
I am wondering how I can either get it to show plainly as '1:1' i.e. as text, or somehow transform it to show as '1-1' or even simply '1 1' so this problem wouldn't persist. I have tried the left right functions, the value function, the text function and none of those work..
Many thanks in advance!!
-tvbuddy01