when downloading sports data team WON – loss records download as dates. I know how to change through numbers/custom to make them look like a W – L record. But now I want to split the column so one column will have W the other L. Though in the cell it looks like W – L, address bar shows date. Some dates show as 4/6/2000 (the cell shows 4 – 6, actual record) others show 10 – 0 – 0, but there are no ties. Is there an easy remedy I would just like W – L in separate columns. And when using it within vlookup not to bring down date numbers again. My thanks in advance for any assistance. greatly appreciate it.
Regards,
gimp55