spread sheet

1) Open an excel workbook and save as Sportwear Retail.xlsx 2) Open with Notepad the file Sportswr.txt select all and Copy 3) In Excel select Cell A1 and Paste 4) in B1 use the formula =CONCATENATE(TRIM(A1),",",TRIM(A2),",",TRIM(A3),",",TRIM(A4)) and Paste in the rest of the column 5) In C1 use the formula =RIGHT(B1,5) and paste in the rest of the column 6) In D1 use the formula =IFERROR(FIND("-",C1),"Incorrect") and paste in the rest of the column