I have data that I have imported from a web site, and I want to refresh it a couple times a week. The problem is, in column J the data appears as 1-1-1 (it's not a date), and the same in Column K. Column K is the last Column of the imported Data. Normally I would use a text to column and use the - to separate the 1-1-1 into 3 individual columns. How can I accomplish this and use the refresh?

Column J has 1-1-1... want to separate them into column L M and N