hyperlink selection in a column

[ccc143]

I have a table where the columns contain links:

ie.

WANTTHISTOAPPEAR.csv

And I added an autofilter so that there could be a drop down option. I want the drop down options to show 'WANTTHISTOAPPEAR' instead of the entire code of

'WANTTHISTOAPPEAR.csv'

to show. This is the code I added on for autofilter:

options(autofilter="yes"
autofilter_width="7em"
autofilter_table="1"
) style=styles.mystyle;

Is there something I need to do to get rid of the additional code from showing in the autofilter?

Thanks,
Connie

[Eric_SAS]

Excel generates the autofilter list from the actual values in the column which means it will spell them all out completely.

[ccc143]

Oh, ok. Thanks!