Excel Hyperlink Management, Functions, and MS Word

[Jrew23]

Is there a text function that returns a specified range within a cell
reference?

for instance given the below conditions, i'd like a1 to return "yahoo"
(characeters 12 through 16 of cell b1) and have the hyperlink show up
in c1

a1 = ?
b1 = http://www.yahoo.com
c1 = hyperlink(b1,a1)
d1 = find("http://www.",b1)+11 returns 12
e1 = find(".com")-1 returns 16

Basically what i'm trying to do is organize my favorite links in excel
(Column C), and then move them to MS Word without having long urls
displayed on my word document. My procedure for doing thing this is by
selecting column C pasting it to MS Word using (Paste Special: Paste
Link | Word Hyperlink)This produces a table, which don't want. So I
remove the table by clicking (in word) Table | Convert |Table to Text.

If anyone has a better way of doing this using macros, let me know.

Thanks!

 

[Barb Reinhardt]

Have you tried entering

=mid(b1,12,e1-d1+1)

in F1?

 

[Beege]

Jrew,

I think that it might be easy to not use excel at all for this. Type a word
in a word document. Highlight it. Go to insert/hyperlink (ctrl-k), then you
insert the URL that you want. You wont see the URL on the page, but it will
highlight as a link, and a ctrl-click will take you to your browser. Am I
reading this right?

Beege

 

[David McRitchie]

A1: 'google
B1: =HYPERLINK("http://www." & A1 & ".com",A1)
A2: 'yahoo
B2: =HYPERLINK("http://www." & A2 & ".com",A2)

copy column B into Word

 

[Jrew23]

Beege,

For so many years I organized my links using the favorites folder in
Internet Explorer... and that eventually got messy - to many links and
too many subfolders. Then I decided to create my own "Web Page" by
using MS Word (I don't know how to use Frontpage) and organized my
links using ctrl+k as you had described. Eventually, I found that even
this got a bit messy. So i figured I'd use excel to organize my
links... I've discovered in some ways, it's a bit easier to organize
and format links through Excel. For instance, using MS word, sometimes
I want to reformat the link - and i have to go through the whole
Ctrl+k, revise the "text to appear" or revise the url In excel, can
make those kinds of changes easily. And also move around cells/columns
etc.

But is it possible to easily move individual cells, ranges, or
worksheets into MS Word???? In any format or outline?... using VBA?

Am I the only oddball organizing links in excel? Probably!?

 

[David McRitchie]

Sorry the material for linking may not be that clear first check this
PC World article
http://www.pcworld.com/howto/article/0,aid,62265,pg,4,00.asp

for Internet Explorer:
Choose Favorites, right-click any item in the list, and select Sort by name.

Netscape Navigator:
alphabetize bookmarks, press Ctrl-B (for bookmarks)
and then choose View, By name (or View, Sorted by name in Netscape 6.1).

Firefox:
Ctrl-B (for bookmarks)
Right click on a bookmark entry, Sort by Name

if you use Firefox you might want set up your favorite bookmarks as
keywords. I am currently keeping my keyword bookmarks in their own
folder on my bookmarks bar just so I can keep track of what keywords
I have and to minimize duplicates or deleting important bookmarks.
http://www.mvps.org/dmcritchie/firefox/firefox.htm#keywords

Keeping track of bookmarks in Excel was probably a lot more popular
when there was no decent way of sorting Internet Explorer bookmarks,
and Netscape messed up theirs as well after version 3, but you can
sort bookmarks now in your browser, probably any browser but certainly
IE, Netscape and Firefox.

 

[Jrew23]

Dave,

Thanks for your replies. I'll read through those articles/links. I
currently use both internet exploerer and firefox. I'm not sure what
version of IE i use, but when I right click within the favorites
right-side pane window, "sort" is not an option (i'm still running on
Windows 2000.. if that means anything).

For the most part, I use Firefox when i'm surfing the web, but for some
reason whenever I try to manage my bookmarks (using firefox), the
browser freezes and I need close it. The bookmarks that created in the
past work... but it won't allow me to organize or add new links.. I
guess I'll search another board for firefox troubleshooting.

 

[Jrew23]

Disregard what I said about Internet Explorer... I played around with
it.. and figured out how to sort by name (through using the drop down
menu instead of clicking the button that opens the pane).

But I think it would be nice to have the option of either sorting
bookmarks by either name, url, or date created.