Listing text values

Hi,

If you look at the following picture you'll see that column D contains text values in rows 566 and 593.

\1

Instead of going down the 10.000 row list and copy paste the text values manually is there a way that a macro can filter them out and paste them somewhere?

Only column D contains the text values.

Thanks in advance,

Once again. Thanks for your help. I will look into the link.