Posted to microsoft.public.excel.programming

QTGlennM

external usenet poster

Posts: 15

Hyperlink display

I have the file path to several files of mine in columb A.
In columb B, I use =hyperlink(A1) and copy down.

The hyperlinks work fine but I only want to display the actual file
name.

example instead of

- G:\Staff Duty Book Folders V2\Book Cover.doc

I want it to display

- Book Cover

Any suggestions I am totally lost on this.
Thanks in advance

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
Hyperlink display problem	Dave Brooks[_2_]	Excel Worksheet Functions	1	March 23rd 08 09:12 PM
Hyperlink display	QTGlennM	Links and Linking in Excel	3	July 30th 06 11:49 PM
Hyperlink display	joel anthony	Excel Discussion (Misc queries)	2	April 24th 06 06:56 PM
Hyperlink Display problem	Panama Red	Excel Worksheet Functions	2	August 9th 05 03:14 PM
Display hyperlink as web address	tatih	Excel Programming	2	June 15th 04 05:42 PM

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

About Us

"It's about Microsoft Excel"

Menu

About Us