LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default How to convert web addresses into hyperlinks

Hello Everyone,

Can anyone help me find a solution to the following problem:

I have a spreadsheet with a single column of hundreds of normal text web
addresses (i.e. http://www.microsoft.com).

Is there an easy way (a macro??) that will take each address in each cell
and convert it into an actual hyperlink?

I know I could do it individually, but with the number of addresses we have
it would take forever.

Thanks very, very, much.

-neil
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Viewing email addresses that are formatted as hyperlinks Marc LaMassa Excel Discussion (Misc queries) 1 September 17th 07 10:29 PM
convert column of text email addresses to hyperlinks all at once Ann Excel Worksheet Functions 1 August 28th 07 08:14 PM
Hyperlinks and Email Addresses in Excel Robert Excel Worksheet Functions 2 July 14th 07 11:49 AM
Extracting email addresses from hyperlinks. Brossyg Excel Discussion (Misc queries) 5 May 11th 07 03:58 PM
Convert entire columns of text email addresses to hyperlinks TSA Excel Worksheet Functions 2 January 20th 05 04:31 PM


All times are GMT +1. The time now is 03:33 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"