Anyone know of a way to turn hyperlinking off in excel?

I'm trying to copy and paste this info: http://www.capitolimpact.com/gw/zipc...ngton%20County


I can try a paste special as text only, but it puts everything into a single cell insted of multiple cells.

 

Paste special, Paste Link (button at the bottom)

Edit: sorry, paste it normally first, then copy that and paste special/paste link. That or off to the side do =a1 and copy that formula down and over to get the table.

 

Paste it into Notepad. That will strip the formatting. Select all in notepad and copy. Paste into excel.

 

i like that way better.

 

Data > Text to Column...

 

 

When I do that, and then try to delete the original paste, the new non hyperlinked stuff goes away as well

 

type 1 into another cell
Ctrl+c in that cell
select other cells
Paste special--> multiply

 

>copy text
>then paste it normal
>copy text again
>select new sheet
>paste special
>select values under paste
>click OK

 

Are you trying to past the link address as text or the contents of the page?

 

literally type the #1?

 

contents of the page, all the zips and counties

 

you the man

 

Yes

 

Glad I could help.

 

too late?

http://members.cox.net/pegan6/Book1.xls

 

anyone know how to remove hyperlink text formatting from an entire COLUMN?
I have a column of numbers, but each number has a URL on it. I want to copy only the numbers and not the url...

 

that's just what I did

 

follow cazzy's idea

 

Oppenoffice's Calc, just copy paste