How can I get rid of the hyperlinks

J

Just Me

I'm making a workbook for my credit card statements so I can track expenses,
when I copy and paste from my Credit Cards online site the column that shows
the dollar amount pastes onto my worksheet as a hyperlink. How can I change
the whole column to just a dollae figure?

Thanks
 
B

bj

a simple way to remove all hyperlinks in a sheet
insert a module and paste this sub

Sub delHyperlinks()

ActiveSheet.Hyperlinks.Delete

End Sub
 
Top