Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Excel2003 Hyperlink Modification
Any help is greatly appreciated. Using Excel2003 on WinXP. All updates current. When hyperlink is inserted that points to a file with a name that has "spaces" in it, when the hyperlink is edited, %20 replaces the "spaces". Need the %20 to not display in the edit hyperlink address window. Also, need to apply the removal of the %20 to already existing hyperlinks. Please contact me if more detail is required. I have found that adding "" around the link will achieve this effect but only on newly created hyperlinks. Or, using the autocorrect function and programming the %20 to equal a "space" but again only on newly created hyperlinks. So to summerize; 1. globally remove from a spreadsheet all %20's with spaces in existing hyperlinks. Thanks. -- lthrwingPosted from - http://www.officehelp.in |
#2
|
|||
|
|||
%20 is simply code for a space character, inserted because some browsers
don't accept literal spaces within addresses. If you're really keen, write a macro that iterates the Hyperlinks collection and uses the Replace() function; but simpler to do nothing at all. "lthrwing" wrote in message ... Any help is greatly appreciated. Using Excel2003 on WinXP. All updates current. When hyperlink is inserted that points to a file with a name that has "spaces" in it, when the hyperlink is edited, %20 replaces the "spaces". Need the %20 to not display in the edit hyperlink address window. Also, need to apply the removal of the %20 to already existing hyperlinks. Please contact me if more detail is required. I have found that adding "" around the link will achieve this effect but only on newly created hyperlinks. Or, using the autocorrect function and programming the %20 to equal a "space" but again only on newly created hyperlinks. So to summerize; 1. globally remove from a spreadsheet all %20's with spaces in existing hyperlinks. Thanks. -- lthrwingPosted from - http://www.officehelp.in |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using the Hyperlink Function and finding filenames | Excel Worksheet Functions | |||
Importing Data from an Access Database Including a Hyperlink Colum | Excel Discussion (Misc queries) | |||
Importing Access File with Hyperlink | Excel Discussion (Misc queries) | |||
Removing hyperlink | Excel Discussion (Misc queries) | |||
How can I extract hyperlink value | Excel Discussion (Misc queries) |