excel trim

Copied large amounts of data need to be operational, but there will always be ahead or behind a space, the data is too big, one by one to delete a lot of trouble, you have any good way?

Click Menu “” Edit “” Replace, Find what:Click the space bar; with:do not enter anything.and then choose Replace All.

Thank you, friends

the other to establish SHEET, in which each element = trim front page and then copy and paste the data value