Pasting Values & Automatically Trim

[an_otter]

Hello!

Real quick question: is there an option in Excel '10 to paste and auto-trim the values?

I've got a very large amount of data that is pasted regularly and sometimes requires trimming, but having to add that extra step is slowing me down. Any ideas?

[Paul]

When you right-click on the cell and choose PasteSpecial, do you see "Trim" as one of the options available?

I don't have 2010, but I'm thinking that's not a feature you'll see anytime soon out of Redmond. A macro could quickly go through the column and trim the cells, though.

Sub trimcells()
Dim ce as Range
For each ce in Range("A1:A100")
    ce.Value = Trim(ce.Value)
Next ce
End Sub

[an_otter]

Thanks plenty! Really helps me out!