LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
giraph
 
Posts: n/a
Default Extracting hyperlink from a cell


Okay.. so I have a list of hyperlinks in my spreadsheet. I need a way
to split the hyperlink column into two columns, one with the
http://website.com part and one with the text of the hyperlink, any
ideas on how to do this?

Thanks for your help.


--
giraph
------------------------------------------------------------------------
giraph's Profile: http://www.excelforum.com/member.php...o&userid=31447
View this thread: http://www.excelforum.com/showthread...hreadid=511351

 
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
Hyperlink problem to cell in same workbook stainless Excel Worksheet Functions 4 November 16th 05 08:10 AM
Hyperlink problem to cell in same workbook stainless Excel Discussion (Misc queries) 1 November 15th 05 04:53 PM
Copy cell format to cell on another worksht and update automatical kevinm Excel Worksheet Functions 21 May 19th 05 11:07 AM
Hide hyperlink cell & replace with macros Jose Excel Worksheet Functions 1 February 14th 05 08:23 AM
Using a formula in a Hyperlink Cell reference sslabbe Excel Discussion (Misc queries) 4 December 10th 04 12:30 AM


All times are GMT +1. The time now is 10:01 AM.

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"