That did the trick. Thanks.

BTW, the reason I didn't fix them in the original sheet is because I used a
formula to fix them, and when I copy and try to paste values, it treats it
like muliple selections and won't let me. Since I had better than 1200
numbers to fix, I figured it would be faster to do it in another sheet than
to select, copy, and paste values for each individual number. Unless there's
a workaround for that too.

"Dave Peterson" wrote:

Not really.

One way around it is to add an extra column. Then mark each of the rows you
want to fix.

Then you can sort by that column to group them all together, copy them, fix
them, and paste them right on top of the original range.

(But why not fix them in the original spot??)

Cene K wrote:

It seems like I'm missing something obvious here.

First, I have a sheet with a lot of phone numbers. quite a few are like
5561234567 and I needed all of them to be like (556) 123-4567. I used a filer
to find all the problem numbers and copied them to a new sheet where I fixed
them. Now I want to paste them back into the original sheet over the old
numbers. But when I try to paste, it pastes even to the rows that are hidden
by the filter. Is there a way to make it so excel ignores the hidden rows so
I can just paste one list on top of the other?

--

Dave Peterson