I have an Excel table filled with ID numbers. On the website they were copy-pasted from, they are links. On the Excel table, they are still links, and it's making it a bitch to move the data around without accidentally opening up browser windows. How can I make Excel forget about the link information?
Lorne: Back in Pylea they used to call me "sweet potato." Connor: Really. Lorne: Yeah, well, the exact translation was "fragrant tuber" but…
'Conviction (1)'
Buffistechnology 2: You Made Her So She Growls?
Got a question about technology? Ask it here. Discussion of hardware, software, TiVos, multi-region DVDs, Windows, Macs, LINUX, hand-helds, iPods, anything tech related. Better than any helpdesk!
Jessica - Nov 07, 2005 11:39:04 am PST #5480 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
DXMachina - Nov 07, 2005 11:40:59 am PST #5481 of 10003
You always do this. We get tipsy, and you take advantage of my love of the scientific method.
Edit-Paste Special-Text
Jessica - Nov 07, 2005 11:45:19 am PST #5482 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
That seems to work only one cell at a time, and I've got 165 items here. Any way to do it in one step?
tommyrot - Nov 07, 2005 11:48:18 am PST #5483 of 10003
Sir, it's not an offence to let your cat eat your bacon. Okay? And we don't arrest cats, I'm very sorry.
That seems to work only one cell at a time, and I've got 165 items here. Any way to do it in one step?
You could try pasting it into Notepad, saving that, and opening the resulting file in Excel, which should then guide you through setting the column break-points.
Kristen - Nov 07, 2005 12:03:11 pm PST #5484 of 10003
That seems to work only one cell at a time, and I've got 165 items here. Any way to do it in one step?
I just did it and it worked. You highlight the whole area, hit copy, then Paste Special and click values. As long as you don't move your cursor, it will paste the values in the same place you copied from.
Jessica - Nov 07, 2005 12:06:02 pm PST #5485 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I tried that, but the links are still active.
Kristen - Nov 07, 2005 12:19:33 pm PST #5486 of 10003
Have you tried copying it all to a blank worksheet? (As values only.)
Jessica - Nov 07, 2005 12:20:41 pm PST #5487 of 10003
And then Ortus came and said "It's Ortin' time" and they all Orted off into the sunset
I gave up and left them linky. They're not sorted the way I'd ideally like, but I can deal. (Really, all I need this for is a list of things to cross off to make sure all these clips ended up on the reel.)
Kristen - Nov 07, 2005 12:31:29 pm PST #5488 of 10003
It's so strange. I can't figure out why it wouldn't work on your computer.
Excel is just weird.
le nubian - Nov 07, 2005 12:49:16 pm PST #5489 of 10003
"And to be clear, I am the hell. And the high water."
Jessica,
copy them, then do Paste Special, then select "text"
You might have to go back and convert the column to numbers. If you don't know how to do that, post back here.