I've turned on the show/hide feature and I can now see that all the rows within that single large row have a carriage return symbol after each row, whereas the others have a square symbol (table cell marker I think). How would I convert the rows in the large field into individual table rows? I've tried find and replace but can't find a caret character for 'table cell marker'
I've attached an image of the part of the list that isn't sorting.