Hello clever technically-inclined people.... I am trying to figure something out in excel and maybe you can help me.

Im using excel 2007 - Basically, I have a column of hyperlinked cells in excel, I need to show the actual URL / Web address and not just the text thats been superimposed over the URL, I know I can do this individually by clicking each cell, going to edit hyperlink and deleting the “text to display” but is there anyway of just bulk doing it for a whole column?

Any help would be greatly appreciated!...
!