Email:      Pass:    Pass?
Close Window   
Free Ebook
Get Your Free Excel
ebook!
Our Top 15 Excel Tutorials
Instant Access!
E-mail:
Subscribe for Free Excel tips & more!
E-mail:


Advertisements


Free Excel Forum

Hyperlink On Single Word In A Cell?

Forum Register
Search Excel Forum Posts, Tutorials, Macros, Tips, and More

Hi all, just wondering is it possible to insert a hyperlink on a single word in a cell containing text, rather than on the whole cell? Or to have more than one hyperlink in the cell, each referring to a single word? My initial research says no, but I would be delighted if somebody could prove me wrong.

Thanks.

View Answers     

Similar Excel Video Tutorials

Helpful Excel Macros

Extract a Word from a Sentence / Cell in Excel with this UDF - Allows for a User-Defined Delimiter
- Extract whole words from a cell or sentence in Excel with this UDF. This allows you to specify which word from a cell y
Extract the First Word from a Cell in Excel - User Defined Delimiter Text Extraction - UDF
- This free Excel UDF (user defined function) returns the first word from a cell in Excel. This extracts the first word f
Open Microsoft Word from Excel
- This free macro will open the Microsoft Word program on your computer. You do need to have this program first. This wi
Open a Word Document from Excel
- This Microsoft Excel macro will open a Microsoft Word document from excel. With this macro, you can open any word docume
Capitalize the First Letter of Every Word in a Cell
- This macro will make the text of any selected cell in excel proper case. This means that the first letter of any word in

Similar Topics







Hi,

Wondering if this is possible, hopefully this is a clear enough picture.


Name Job
Link 1 Bob 1
hyperlink 1 2 Bill 2
hyperlink 2 3 Brad 3
hyperlink 3
The LINK column are 3 microsoft word files hyperlink'd to my excel file.

(Q) Would it be possible to write a macro/forumla/something to be able to look for a word within the hyperlink'd files. If the word is found, then that person will show up.

Lets say I was looking for the word "Fork" and it was in hyperlink 1. I would like to get:


Name Job
Link 1 Bob 1
hyper 1
I hope this makes sense. I know a little about macros and formulas, but not much.

Thanks for any help,
Jwing


Hi,

I'm wondering if its possible to start a makro by clicking on a single word in a cell (I basically want to connect a macro to the word like you connect it to an object)? The cell contains a text with multiple sentences.
I have tried to create an object containing just text with the same word, but the object changes size when I zoom. If there is any way to prevent this it could be a good solution.

thanks in advance

/Erik


I have a database set up in Excel where I can click on a cell and it opens a Word file. The cell is just a hyperlink to a network drive where the Word file is stored.

When I click on the hyperlink, Excel is minimized and Word (containing my file) is brought up. When I close Word, Excel stays minimized. I'm using two monitors, one to look at the Excel file and one to look at the Word files, and when I look at more than one file it because a click-fest to keep Excel up.

Is there a way to keep Excel from minimizing when I open a hyperlink?

Thanks!


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!




Hi all, i posted this thread previously a while ago and couldnt make myself understood, so I'm gonna try again and put this in plain english this time.

Imagine if the word below was a hyperlink to a webpage somewhere;

House


I would like to know how to get excel to look at this paticular page and return that one word to a cell, so in this example, I would like cell A1 to to contain the word house.

I do not need any information about where the link is referring to, I already have this information.

All I need is for excel to look at this link and tell me what it is called.

Hope that is clear enough, I will give further examples if need be.....

Thanks in advance for any help with.....


I am wondering if it is possible to have a hyperlink from cell to cell.

Example: I will have a Cell with the word Criteria in it. I want people to be able to click on that word and it takes them to something (another cell or what have you) that would have the criteria.

It would be like a definition.

Maybe it isn't called hyperlink but I want it to do the same thing.


Hi,

I need to create a hyperlink which takes me from a cell in excel to a bookmark in a word doc which will be inserted into the excel file itself. The problem i have is that the users of the spreadsheet will not have access to a shared server (so i can't do a regular hyperlink), but will have to reference specific parts of the word doc at a click of a button.

I've been able to open the file using a macro, but not get to the bookmarks in the word doc.

Please ask if further clarification of my problem is needed.


I am trying to hyperlink a word in a sentence to another list, I am able to do this by cell only Is there anyway possible I can hyperlink based on one word?


Help!!!

Can I create a hyperlink to a word in a cell (as opposed to the cell itself).

For example, if cell A1 has the following text

"Topics to help build your tool"

How can I hyperlink the word "Topics" only


I use excel '08 for Mac, and would like to hyperlink a word/phrase to a specific word or pdf document on my computer.

Here's what I do: right-click the word/phrase in the cell, click "hyperlink," and select "document" then click "ok"

Here's what happens: although the word then appears hyperlinked, when I click on it I get the message "cannot open that specific file".

Any suggestions? Thanks in advance, Nate


How can I hyperlink from word to a particular cell in an Excel spreadsheet. I have tried naming the cell, but I cant find the function on the toolbar to allow it then to be linked. I am assuming its like making a bookmark in a word doc.
THanks for your help


I am trying to get a hyperlink to transfer to a cell that generates a random word from a set list. Here is the code in the cell:

B2=INDEX($A$26:$A$49,RANK(H27,$H$26:$H$49)

What i am looking for is the words in A26-A49 to appear in cell B2 as a hyperlink thats opens a picture. I have the hyperlinks in the list and have tested, however when i generate the list the word from A26-A49 appears just not hyperlinked. Im thinking the hyperlink is attached to the cell not the words. Thanks for your help.


I thought this would be pretty straight forward but I guess I was wrong. I
want to create a hyperlink to a web site within a cell. But, I have a large
amount of text in the cell and I don't want the whole cell hyperlinked - just
the one word.

Can this be done?



How do you make a macro that does the following: go to next cell down in Column B copy contents (a single word) of that cell select entire Column A find first instance, in Column A, of the word that was copied from Column B, above, (the word is part of a sentence in a single cell in Column A), underline just that word (not the whole sentence) in Column A loop


I've tried creating a hyperlink between text content in a .xls cell and a distinct location in a secondary MS word document. Said location is defined by a bookmark. Result>

Error message: Microsoft Office could not open this file or parse a file of this type.

Error Detail: Certain file formats, such as XML, do not support bookmarks so you cannot create a hyperlink to a bookmark in a file that does not support bookmarks. You can either hyperlink to the file without any bookmarks, or change the file format so you can insert bookmarks into and hyperlink to the bookmark.

I'm not sure how to interpert and resolve. Suggestions would be appreciated. The need requires a hyperlink to a specific location within the word document, so hyperlinking to the file doesn't help.

Thanks!


Hi Folks,

Is it possible to create a macro or code for the following issue?

In column B I have a list of names (which could build to 500) that I aim to hyperlink each to their own word doc file. When adding a new name, can a macro run to check down the list to see if a hyperlink is made, if not add the link to a word doc using the same title as the cell in another folder. Thus it has to create the word file before it can be linked?

I have a button that will put the names in alpha order.

Cheers
Marty


Hi all!

Someone here is using Excel 2003 and would like to create a hyperlink from a cell to a .doc file. When we try to create the hyperlink, we navigate to the directory that stores the .doc file, but Excel isn't letting us "see" the .doc files that are in the directory.

Is it possible to link a cell to a Word .doc? My co-worker could swear that she's done it before.

Thanks much!

[edit]
I see how to hyperlink to a file

=HYPERLINK("path to sample .doc on the desktop here")

but the hyperlink opens the directory instead of opening the file in Word. We'd like the file to open in Word, as she's seen before.

[end edit]


I hope someone can help - this is above my skills.

I have a column in excel with the word Yes, No, or Check. I would like that word to show up as a hyperlink to a cell in a different worksheet based on a value in the first sheet.

For instance

Sheet 1:
Tomato YES
Carrot NO


Sheet 2:
carrot
Tomato

The word yes should show as a hyperlink which directs to the cell in sheet 2 named Carrot. The word NO (cell b2) should direct to carrot in worksheet 2 (cell a1) based on the fact that that word is also contained in sheet 1 cell A2.

HELP?

Thanks in advance


I am trying to link to a specific location in a word doc from Excel.
Can I add something to the hyperlink to find a string of text in the
word doc. Or run a macro, open the word doc and then search for a
string of interest?, etc?? Suggestions?




Hi
Can someone please help me..

Heres what I want to do.

Whilst in Excel create a hyperlink to a specific docoument in Word (Thats the easy part) once Ive finished with the Word document either a button with a macro or hyperlink back to my excel sheet and closing the word document.

Many Thanks

Shaun


Can this be done? This is what I want to do. Say I have a workbook open and my A column cells are filled with (example) Mike-1 in the first row Mike-2 in the second row and so on. Now I have another folder on the computer with Word documents that I want to hyperlink to. The corresponding Word file is named mike1. So I want Excel to go through column A and Hyperlink to the corresponding Word file. Is it possible to do this?


Ok,

I have a bunch of tabs. Each tab has a name like "WO-101", "WO-102", etc..

The names are on a datasheet that is automated from a main sheet thanks to Akashwani......

I have a Table of contents page that pulls from the datasheet using just this formula:

=IF(StoreData!A2="","",StoreData!A2)

That way if the cell = "WO-101" then the cell on the Table of contents page = "WO-101"

Now the datasheet creates a copy of the "WO-101" sheet and names that sheet tab "WO-101"

What i need from the hyperlink guru that responds to this is a maco or formula that will change the word "WO-101' to a hyperlink automaticlly and direct that link to the copied page named "WO-101".


In short, I need each word that pops up in my column to hyperlink to the sheet that matches it's name. So I can click on the word and go directly to the applicable sheet. Keep in mind the cell where the word pops up is set to a formula {=IF(StoreData!A2="","",StoreData!A2)}

Any takers?


Hello,

I want to hyperlink one specific word from one sentence in one cell.
eg: "This is my Google."
This is one sentence in the cell and i want to add hyperlink the word google but rest should remain as it is.
Can someone help?

Thanks,
Parth


hi guys, is it possible to make a hyperlink in say cell 1A to link to page 3 in a word document? ive tried creating a macro but to no joy.
thanks


Hi all,
I m new to Word and I would like to insert (imbed?) into a WORD doc a link to another WORD doc on my hard drive and/or the data base I'm connected to.

Please give me ur suggestions.

Thanks
J.Wills