Excel 2007 Beta 2 - Remove hyperlinks from a column

  • Thread starter Cornelius J. van Dyk [MVP]
  • Start date
C

Cornelius J. van Dyk [MVP]

I have a column in Excel where I pasted user names from SharePoint.
Unfortunately the values now have a URL association with it.
Is there any way to remove the URL from the entire column without having to
do it line by line?

Thanks
C
http://spaces.msn.com/cjvandyk
 
M

MDubbelboer

multiply each cell by 1 using paste specia

then change the text formatting to make it all uniform if it wasn'
already
 
D

David McRitchie

There are some things to watch out for in using Paste Special multiplication
1) If you select an entire column or data beyond your used region you
will change your last cell (Ctrl+End)
2) If you include a blank cell in the range to be changed, it will be changed
to a 0 (zero).

My preference is a macro
http://www.mvps.org/dmcritchie/excel/buildtoc.htm#DelHyperlinks

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"MDubbelboer" ..
 
Top