Posted to microsoft.public.excel.worksheet.functions

Connie Martin Connie Martin is offline

external usenet poster

Posts: 251

Hyperlink formula

Thank you so much! That works. Connie

"Gary''s Student" wrote:

Lets say A1 contains:
http://www.cnn.com

In B1 enter:

=HYPERLINK(A1,A1) and copy down

--
Gary''s Student - gsnu200737

"Connie Martin" wrote:

My spreadsheet of over 10,000 rows has a column with company internet
homepage addresses in it. Is there a way to convert that whole column to
hyperlinks in one shot? Connie

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
what formula will get the url from a cell with a hyperlink?	polytx	Excel Worksheet Functions	7	May 29th 08 06:54 AM
Hyperlink Formula	Confused at Work	Excel Discussion (Misc queries)	0	October 3rd 06 06:53 PM
How to extract the url in a hyperlink using a formula	pako_1972	Excel Worksheet Functions	1	September 7th 06 05:08 AM
Hyperlink in nested formula not linking	KarenF	Excel Discussion (Misc queries)	7	August 10th 06 10:43 PM
hyperlink formula	David McRitchie	Excel Discussion (Misc queries)	0	November 27th 04 05:32 PM

All times are GMT +1. The time now is 09:16 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us