downloaded data/WON – LOSS records arrived as DATES

[gimp55]

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

[kersplash]

Can you attach a sample workbook mocking up your expected result.

Go Advanced -> Manage Attachments -> Upload

[gimp55]

This is outcomes when I downloaded
Home
Team Win-Loss Win % MOV ATS +/-
Abl Christian 10-0-0 100.00% 26.3 5.8
Air Force 7-3 70.00% 6.1 4.6
Akron 10-1 90.90% 15.3 2.9
Alab A&M 3-4 42.90% -3.3 3.6


This is how I'd like it to be
Home
Team Won Loss Win % MOV ATS +/-
Abl Christian 10 0 100.00% 26.3 5.8
Air Force 7 3 70.00% 6.1 4.6
Akron 10 1 90.90% 15.3 2.9
Alab A&M 3 4 42.90% -3.3 3.6

[gimp55]

saved as text went to advanced/attachment/? nothing, new to forum will figure it out. Above doesn'tline up as if in cells.

[JeteMc]

Hello gimp55 and Welcome to Excel Forum.
These formulas work for the sample data given.
For wins: =IF(ISTEXT(B2),VALUE(LEFT(B2,SEARCH("-",B2)-1)),VALUE(MONTH(B2)))
For losses: =IF(ISTEXT(B2),VALUE(MID(B2,SEARCH("-",B2)+1,SEARCH("/",SUBSTITUTE(B2,"-","/",2))-(SEARCH("-",B2)+1))),DAY(B2))
As for uploading files: To attach a sample workbook (not a picture or pasted copy) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
Let us know if you have any questions.

[gimp55]

file uploaded hopefully in correct format
gimp55

[FlameRetired]

If I understand correctly try this in H4 filled down and across to I7.

Please Login or Register  to view this content.