jenbobenbo

I expect you got this sorted already as it was some time ago, but I just came across your post yesterday when trying to sort the same issue. I realised that there was a '/' identified as a delimiter in my 'text to columns' settings in Excel left over from a previous use, and this was what was splitting my data. I took it out and re-ran the affected SIMS report and it was fine again.