Two ways to remove spaces at the beginning/end, and only keep one space when multiple spaces in the text.

1. Select Paste(Trim Spaces) to paste.

2. Use LT function Trim(), like Trim(A) to do this for column A.