How to paste a list of hyperlinks (e.g. list of external blog links)into Excel and keep the titles a

[slarson650]

I'm trying to copy groups of titles and the associated hyperlinks from
a web page into either excel or word (both really). Office on my PC
does this by default, but on my Mac with Office 2004, the list always
comes in without links. I can do it one-by-one, but I need to copy/
paste long lists. Any ideas? Is it even possible?

Susan

 

[Daiya Mitchell]

What browser are you using? Because different browsers put different
information on the clipboard.

Also, can you link the page in question (or a similar one) here?

And, what exact version of Office 2004?

Because I copy web text with links into Word all the time, and the links
come along without a problem. Just copied a whole blogroll from Safari
into Word.

 

[John McGhie]

Hi Susan:

It's "possible", but it's nasty...

Office 2004 can't retrieve HTML from the clipboard.

What you have to do is

1) Display the web page as "Source" and

2) copy that.

3) In Word, save the document as "Web Page".

4) Then change the file extension to ".txt".

5) Then open it in TextEdit as text, and

6) paste in the raw HTML.

7) Then put the file extension back to what it was,

8) open it in Word, and tidy it up,

9) then save it back as a .doc document.

It's not as bad as it sounds: you get quite quick at it after a while...

Cheers

I'm trying to copy groups of titles and the associated hyperlinks from
a web page into either excel or word (both really). Office on my PC
does this by default, but on my Mac with Office 2004, the list always
comes in without links. I can do it one-by-one, but I need to copy/
paste long lists. Any ideas? Is it even possible?

Susan

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]

 

[Daiya Mitchell]

You know, I didn't even notice she wanted Excel.

It works for me in Word--I paste from Safari 2 into Word 2004, links
come in underlined and colored--when I hit option F9 they are hyperlink
fields, and when I click on the underlined/colored text, it takes me to
the web. Drives me crazy, in fact, because I sometimes click accidentally.

If I then paste from Word into Excel, Excel has the hyperlinks also.

 

[John McGhie]

Thanks Daiya:

I wasn't going to take a guess that it works in Safari 2...

I must install that...

Cheers

You know, I didn't even notice she wanted Excel.

It works for me in Word--I paste from Safari 2 into Word 2004, links
come in underlined and colored--when I hit option F9 they are hyperlink
fields, and when I click on the underlined/colored text, it takes me to
the web. Drives me crazy, in fact, because I sometimes click accidentally.

If I then paste from Word into Excel, Excel has the hyperlinks also.

--
Don't wait for your answer, click here: http://www.word.mvps.org/

Please reply in the group. Please do NOT email me unless I ask you to.

John McGhie, Consultant Technical Writer
McGhie Information Engineering Pty Ltd
http://jgmcghie.fastmail.com.au/
Nhulunbuy, Northern Territory, Australia
+61 4 1209 1410, mailto:[email protected]