or use "=HYPERLINK(URL, text)" where the displayed text can be different than the full URL?
-----Original Message----- From: Manuel Andres Ramirez [mailto:[email protected]] Sent: Friday, November 11, 2011 06:18 To: [email protected] Subject: Re: Question Restrict Cell entry to width of cell El 10/11/11 16:26, Brian Barker escribió: > At 13:08 10/11/2011 +0100, Martin Hediger wrote: >> Am 10.11.11 12:52, schrieb Harold Fuchs: >>> On Wed, 2011-11-02 at 10:17 +0100, Martin Hediger wrote: >>>> I have a Calc spreadsheet where in one column contains links to >>>> files on my computer, so the entries are long in terms of number of >>>> characters. I dont need to see the whole path all the time, and I >>>> wanted to know how I can adjust that only the part of the path >>>> fitting into the column width is displayed. Seeing the complete >>>> path is confusing and distracts me somehow. Is it possible to >>>> adjust this? >>> > > Hi, I'll recomend you use the function =right() or =left(), maybe you can extract part of the link in another column and hide the original. bye. -- Manuel Andrés Ramírez P. Administrador Informático GNU/Linux Registered User:412887 www.obtengalinux.org <<Yo Tengo mi Office Legal y no pagué por su licencia>> "El placer más noble es el júbilo de comprender" (Leonardo Da Vinci) --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
smime.p7s
Description: S/MIME cryptographic signature
