I’m using spreadsheets from time to time to keep minutes of phone calls. Definitely not the best way to do it, but.. well..
In these spreadsheets I have a column with numbers and I want them to link to a website so it opens up the case the notes are related too. I ended up using ‘Find & Replace’ like this in OpenOffice 3.0 (should work since 2.4):
- Find:
([0-9]{4,5}) - Replace:
=HYPERLINK("https://yourwebsite.loc/$1"; "$1")
Make sure you switch on the ‘Regular expressions’ in ‘More Options’.
Silly, but it kept me busy for 14 minutes..