Hyperlinks - Text to display

[Elegidos]

Hi,

I have quite of few of cells in a column it only includes a hyperlink in the cells. The links are quite long, so the cells expands. The easy and slow, slow way to change the Text to display is by right clicking on the mouse and changing it manually each cell with a link.

My question, is there a way to change the text to display with a function or something similar?


Thanks
Elegidos (Spain)

[DonkeyOte]

What is to determine the Text to Display content of each link ?

[Elegidos]

What I really want the text to display is the last 8 characters of the link. But if isn't posible just want to put any type of text to reduce the size of the link .

[DonkeyOte]

So does something like the below work for you ?

Please Login or Register  to view this content.

[Elegidos]

Yeah!! Seems like that might work just great . The only problem is where do I put the following code? If its VBA, in excell I've never used it and don't know what to do .



Thanks again.

[DonkeyOte]

In XL hold ALT and press F11 (brings up the VBE window), then ALT + I -> M and paste the above code into the resulting window.

Back in XL you can call the subroutine either via the Tools -> Macros menu or by pressing ALT + F8, selecting routine and pressing Run.

Obviously macros must be enabled - to check your Macro security settings use Tools -> Macros -> Security ... I would advise Medium (never Low). On medium security when opening files containing VBA you will be prompted to either Enable/Disable macros (Low will auto enable).

[Elegidos]

Yeah!! Seems like that might work just great . The only problem is where do I put the following code? If its VBA, in excell I've never used it and don't know what to do .

http://www.excel-vba.com/vba-prog-1-4-editor-code.htm

[Elegidos]

Thanks for the help DonkeyOte.

[DonkeyOte]

In your link they're using Objects rather than Modules to store the code... unless your code is specifically related to an Object (ie a Sheet / Workbook / UserForm etc) store code in Modules (as outlined in my prior post).

[Elegidos]

OK, thanks. I will do so .