Webdevelopment
Drupal
Betriebssysteme
Design
Sonstige
Di., 02/10/2012 - 11:45
Body
http://www.jerryleventer.com/excel-tutorial-how-to-convert-plain-text-links-into-hyperlinks/
http://www.niallflynn.com/random-news/convert-urls-to-clickable-links-in-excel/
Makro Editor öffnen, ALT+F11
Rechtsklick "Einfügen->Modul" und dort im Fenster folgenden Text rein, speichern.
Text bzw. Zeilen markieren und Makro anwenden, Alt+f8
- Public Sub Convert_To_Hyperlinks()
- Dim Cell As Range
- For Each Cell In Intersect(Selection, ActiveSheet.UsedRange)
- If Cell <> "" Then
- ActiveSheet.Hyperlinks.Add Cell, Cell.Value
- End If
- Next
- End Sub
Thanks for the link back
Thanks for the link back loads more Excel help here; http://www.niallflynn.com/blog/