|You probably have spaces in the original data. You can test this by editing one of your source cell and using the mouse, place the cursor a before the last letter, number or symbol. Then press the right arrow once. your cursor should now look like its at the end. if you press it again you should see it move again to the right. The number of times it moves is the number of spaces.|
Alternatively try this assuming your source data is in column A starting row 5
this should convert all spaces to + so you can actually see them.
There are ways of stripping out the extra spaces at the end. First do a check and see if there is a pattern, always just one space? if the number of spaces at the end varies, can you tell what the maximum number of spaces is?
if its a constant number just place the following in column B
=left(A5,len(A5)-NUMBER OF CONSTANT SPACES)
if it varies let me know and there are a few ways of dealing with it. The easiest is through VBA but that is not my forté. I deal with it through a series of if statements but I can only deal with a certain maximum number of spaces at the end.