It's actually two steps. First, use a TRIM function to strip out the
...and copy down as far as needed.
Next, copy the entire set of cells you just created and select Copy, select
the first cell in the original data, then Edit > Paste Special > Values to
paste the new data back over the top of the old. You can now delete the
Repeat with any other columns.