If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Re. Internet links
Hi!
Sorry if this is been seen twice by some people - I did not see this option for links!! I have been given a database of names, addresses and website addresses in an Excel spreadsheet. The website addresses do not appear as a hyperlink. Is there anyway to Format that row to make all of the addresses appear as links that I can click on that will then just direct my browser to that website. This works fine if I input data from scratch with www as a prefix but not with existing data. I am using Office 2003 on Win XP Home. Please Help as the database is quite considerably large and business-critical. Best Wishes Andy .. |
#2
|
|||
|
|||
Re. Internet links
Hi,
You can use the HYPERLINK() function: HYPERLINK( web_address , text_to_be_displayed ) Say your web addresses are in column A starting in A2 In B2, enter the formula: =HYPERLINK(A2,A2) Fill down along the data. -- Regards, SĂ©bastien |
#3
|
|||
|
|||
Re. Internet links
A suggestion for your formula,
since you are already showing the URL in cell A2, you can simply show something like [x] or [link] in your cell with the Hyperlink formula. =HYPERLINK(A2,"[link]") or possibly like =HYPERLINK("http://" & A2, "[x]") --- HTH, David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001] My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm Search Page: http://www.mvps.org/dmcritchie/excel/search.htm "sebastienm" wrote in message ... Hi, You can use the HYPERLINK() function: HYPERLINK( web_address , text_to_be_displayed ) Say your web addresses are in column A starting in A2 In B2, enter the formula: =HYPERLINK(A2,A2) Fill down along the data. -- Regards, Sébastien |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Links in Internet Explorer Not Opening Properly | Bruce Hagen | Outlook Express | 10 | July 1st, 2004 04:16 AM |
links to internet | shari | General Discussion | 1 | June 4th, 2004 06:15 PM |
outlook2000 modprof - how to create multiple internet mail services | Roger | General Discussion | 1 | June 3rd, 2004 07:15 PM |
Quick links for Office 2003 | djohnson | Setup, Installing & Configuration | 1 | April 29th, 2004 10:36 PM |
Excel 2000 converts UNC links to relative - need to preserve UNC links! | Jeff Adams | Links and Linking | 3 | April 15th, 2004 05:46 PM |