A set of appscripts created for various purposes, mostly for Google Sheets.

GET_HYPERLINK_TEXT(cellAddress)

Add the formula =GET_HYPERLINK_TEXT("A1") - The cell address should be in quotes. You can use it this way =GET_HYPERLINK_TEXT(CONCAT("A",ROW())) to copy the formula across rows. Replace A with the correct column name.

Contact Us

www.zyxware.com