Excel 2007 Beta 2 - Remove hyperlinks from a column

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Cornelius J. van Dyk [MVP] - 19 Jul 2006 18:40 GMT

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

Reply to this Message

Ragdyer - 19 Jul 2006 18:55 GMT

Probably yes.

Post some varied examples of your data.

Signature

Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

>I have a column in Excel where I pasted user names from SharePoint.
> Unfortunately the values now have a URL association with it.
[quoted text clipped - 5 lines]
> C
> http://spaces.msn.com/cjvandyk

Reply to this Message

MDubbelboer - 19 Jul 2006 20:27 GMT

multiply each cell by 1 using paste specia

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

Reply to this Message

David McRitchie - 29 Jul 2006 18:49 GMT

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" ..

> multiply each cell by 1 using paste special
>
> then change the text formatting to make it all uniform if it wasn't
> already.

Reply to this Message

Rate this thread: