Hello,

I have in an Excel sheet a column with text describing an access path a
a file like this :

columnn A

C:\photo\1.jpg
C:\photo\2.jpg
C:\photo\3.jpg
C:\photo\4.jpg
...
C:\photo\2000.jpg

I find a way to transform automaticaly and easily all this text in
hypertext links and avoid to copy, create an hypertext link, paste,
browse, ... for each cell of the column ...

Thanks from Paris !

(E-Mail Removed)


--
christopherocca
------------------------------------------------------------------------
christopherocca's Profile: http://www.excelforum.com/member.php...o&userid=34367
View this thread: http://www.excelforum.com/showthread...hreadid=541444

Please, read : I am looking for a way to ...
and not : I find a way to !

Sorry for my Englis

--
christopherocc
-----------------------------------------------------------------------
christopherocca's Profile: http://www.excelforum.com/member.php...fo&userid=3436
View this thread: http://www.excelforum.com/showthread.php?threadid=54144

Assuming your data is in A1:A10

Enter in B1:B10: (french locale)
=LIEN_HYPERTEXTE(A1;"Some text")

In english:
=HYPERLINK(A1;"Some text))

If you don't specify 2nd parameter, it will default to the text of 1st
parameter

HTH
--
AP

Bonjour de Montauban!


"christopherocca"
<(E-Mail Removed)> a écrit dans
le message de news:
christopherocca.27onuy_1147418100.98...rum-nospam.com...
>
> Please, read : I am looking for a way to ...
> and not : I find a way to !
>
> Sorry for my English
>
>
> --
> christopherocca
> ------------------------------------------------------------------------
> christopherocca's Profile:
> http://www.excelforum.com/member.php...o&userid=34367
> View this thread: http://www.excelforum.com/showthread...hreadid=541444
>