Batch rename hyperlinks
I have a column with a long URL http://blblblblbl... There are about 300 rows in the sheet. I'd like to change the display text of the links to Preview for all of them.
Is there a way? I can not do this one by one. (multiple sheets with the same set up).