hi guys -
i have attached a workbook which demonstrates my issue.
As you will see, some of the range C37:P50 of sheet 1 are returning #n/a. This is because, (i think) that the data in Col C of the Data tab is unclean -ie leading or traililng spaces. I was advised by another member earlier of the text to columns method of resolving this, however, that darstedly break line keeps returning. Please could someone let me know what i am doing wrong. Cheers
Bookmarks