Thanks.

But I don't see any post by you regarding pivot tables.

Bernie


"TomHinkle" wrote in message
...
Bernie,

I'm an excel geek too and have been for a LONG time... That's by far one
of
the most creative (and useful) tips I've heard.. Props..

(can you see my question on pivot table sorting??)

"Bernie Deitrick" wrote:

Pankaj,

Select column A, then use Edit / Go To... Special Blanks OK. Then type
an
equal sign, press the up arrow key once, then press Ctrl-Enter. Then
reselect column A, copy, and paste values, and you're done.