I imported a sheet from Excel that contained Hyperlinks. They are not displaying properly in Zoho, they all display "REF#" in the cell, and the cells contain "=HYPERLINK("[link text]";"[display text]")

Is there any automated way to convert these links to be readable by Zoho?

Is there a Macro that you can give out to convert these links?