If you are not familar with working in VBA you can highlight the whole
column, Press Ctrl C to copy the contents. Then rightclick the first row and
click 'paste Special'. Select the 'Values Only' radio button and hit Okay.
That should eliminate all the hyperlinks and leave their text Values.

"Don Guillett" wrote:

try
columns(1).hyperlinks.delete

--
Don Guillett
SalesAid Software

"Sam" wrote in message
...
Column has data that I would like to displayed as plain text to users
instead
of having a hyperlink associated with it.

I can do one cell at a time but how would I do an entire column?