I got a question concerning Microsoft Word 2007 (work)
Please register to participate in our discussions with 2 million other members - it's free and quick! Some forums can only be seen by registered members. After you create your account, you'll be able to customize options and access all our 15,000 new posts/day with fewer ads.
Like I said before, I'd rather not do it manually.
Not sure what more you want. No matter what option you use, you will have to do some manual work.
I don't think there is a button to click that will automatically turn multiple items into hyperlinks. Is this really too much work?:
1. Open Word document with links
2. Press ctrl + A to select All items
3. Right click on choose Copy
4. Open Excel
5. Click in Cell A1 and choose Paste
6. If the link is not the full URL, do a Find/Replace for www and replace it with h t t p :// w w w (I put spaces so it doesn't turn into a link)
6. Enter =HYPERLINK(A1) in cell A2
7. Go to the lower right hand corner of A2, right click and drag all the way down the sheet to auto fill the formula.
8. Test a link
9. Copy the links back into Word
That's less than 10 steps and 2 of them are to open the applications. Heck, forward me the document and I will do it for you myself.
You obviously do not understand find/replace. Good luck with your quest.
You might want to look back at the other posts on here. People gave ideas on how to avoid doing manually. So please, don't tell me that I don't understand. Thank you.
You might want to look back at the other posts on here. People gave ideas on how to avoid doing manually. So please, don't tell me that I don't understand. Thank you.
From your comments, it is no leap to think you do not understand Find/Replace/All but by using Excel instead of Word you gain the advantage of being able to have the hyperlink in a very narrow column and use the rest of the cells for description.. I tried messing in word (since I do not use Word 2007) and found it much harder to activate a hyperlink than in Excel. (I guess I just don't understand)
You might want to look back at the other posts on here. People gave ideas on how to avoid doing manually. So please, don't tell me that I don't understand. Thank you.
There wasn't a single recommendation here that doesn't require some manual input on your part. What you don't understand is the amount of "manual" work required between the differing methods. Find/replace is so easy and requires such a small amount of input on your part that rejecting it as a possibility does show that you don't understand how it works.
And in case you missed it, it's not just my opinion:
Quote:
Originally Posted by bs13690
Yep, search/replace would work. Sometimes, I forget the easy solutions. I was thinking of a more complicated way to do it.
There wasn't a single recommendation here that doesn't require some manual input on your part. What you don't understand is the amount of "manual" work required between the differing methods. Find/replace is so easy and requires such a small amount of input on your part that rejecting it as a possibility does show that you don't understand how it works.
And in case you missed it, it's not just my opinion:
I saw plenty of Excel suggestions. So I am not sure what point you're trying to make here.
I saw plenty of Excel suggestions. So I am not sure what point you're trying to make here.
So you consider typing www. in one box then http;//www. into another then clicking Replace All once more work than copying it all into Excel, adding info in a cell, do some click and drag, and copying it back?
Quote:
Originally Posted by bs13690
Not sure what more you want. No matter what option you use, you will have to do some manual work.
I don't think there is a button to click that will automatically turn multiple items into hyperlinks. Is this really too much work?:
1. Open Word document with links
2. Press ctrl + A to select All items
3. Right click on choose Copy
4. Open Excel
5. Click in Cell A1 and choose Paste
6. If the link is not the full URL, do a Find/Replace for www and replace it with h t t p :// w w w (I put spaces so it doesn't turn into a link)
6. Enter =HYPERLINK(A1) in cell A2
7. Go to the lower right hand corner of A2, right click and drag all the way down the sheet to auto fill the formula.
8. Test a link
9. Copy the links back into Word
That's less than 10 steps and 2 of them are to open the applications. Heck, forward me the document and I will do it for you myself.
All Tek_Freek is saying is if you open the word document, go to "Find And Replace," type www. in the "find" field and http:// in the "replace field" and hit "replace all" it will fix all the links at the same time.
Please register to post and access all features of our very popular forum. It is free and quick. Over $68,000 in prizes has already been given out to active posters on our forum. Additional giveaways are planned.
Detailed information about all U.S. cities, counties, and zip codes on our site: City-data.com.