creation of automatic hypertext links

C

christopherocca

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 !

[email protected]
 
C

christopherocca

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

Sorry for my Englis
 
A

Ardus Petus

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"
<[email protected]> a écrit dans
le message de [email protected]...
 
Top