I have two sheets, a and b, which have a common identifier which I am joining on. The issue is when I do the join there are some entries which should be matched but are not coming over in the join. The odd thing is if I take these entries out of sheet b and put them in a separate spreadsheet then the join works as expected. It points to some sort of issue with my excel sheet. I have removed page breaks etc and tried copying all the data from sheet b into a new sheet to no avail.
Strange one but any one any ideas ?
