Get Text From Hyperlink
I'm trying to get just the text of a hyperlink from a cell in Numbers 3.0. My table looks like this:
A1=hyperlink("http://www.google.com/", "Google")
A2=t(A1)
In Numbers 2.3 cell A2 is just the word Google. In Numbers 3.0 cell A2 is an exact copy of A1 - the word Google with a hyperlink included. I'd like to find a way to remove that hyperlink in a different cell. I think this is a bug in 3.0.
MacBook Pro (13-inch Mid 2009), OS X Mavericks (10.9)