So I typically input the data from my excel and copy past it here.
But many of my records look weird, and i have to manually fix them.

How can I Avoid this problem ?

in the scrreen shot only the partial name shows up.