Urgent

Hello friends,

i need a command which can help me in consolidation of data. i have exported some party name from busy software, then pasted to another workbook. now problem is in using sumif formula. In exported data, there is lots of space in a cell after text while in pasted data there is no space as same. now problem is how i can change the exported data as just simple typing text.

please help me if that is possible