creation of automatic hypertext links

  • Thread starter Thread starter christopherocca
  • Start date Start date
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 !

(e-mail address removed)
 
Please, read : I am looking for a way to ...
and not : I find a way to !

Sorry for my Englis
 
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 (e-mail address removed)...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top