text to col = cleaning data

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

hi Blake7, 1 of the reason is C35 of Sheet1 has an additional space. E35 too. i checked a few of the data in Column B & they dont exist in "Data". you could use IFERROR to handle these errors once you are sure it is purely because they dont exist

you need to clean up the titles in C35:F35 on sheet1 is all

hi and thanks for looking- do u have any ideas on how i can go about cleaning and sorting this data? thanks

jp - hows it going dude? have you converted to mormanism yet!!!! thanks for your advice.....

if I had more than one wife do you think I'd have time to be here? ;-)