Try this little macro:

Sub HyperBeGone()
For Each r In ActiveSheet.UsedRange
If r.Hyperlinks.Count 0 Then
r.Clear
End If
Next
End Sub

--
Gary''s Student - gsnu2007f


"Kent" wrote:

Dear all,

I have got some hyperlinks in my excel worksheet which may be removed and
replaced by characters one by one. HOw can these hyperlinks be removed all
in the same time?


Thanks you