Excel 2007 Beta 2 - Remove hyperlinks from a column

[Guest]

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

 

[Ragdyer]

Probably yes.

Post some varied examples of your data.

 

[MDubbelboer]

multiply each cell by 1 using paste specia

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

 

[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



"MDubbelboer" ..