Hello and thanks for your help in advance.
I was trying to use the action “Extract URL” in “Formatter by Zapier” to extract the hyperlink from a cell of an Excel spread sheet but it only retuened text “Locatrion Link”. I’m only interested in getting the link from this cell.
Was just wondering is there a way to extract the hyperlink from an excel spread sheet cell?
Thanks
Best answer by Troy Tessalone
In the Zap trigger DATA OUT, Excel is returning the “visible” value for the cell, not the formula value.
The URL would need to be in another cell to be used in Zap action steps.
+14Hi
For us to have context, post screenshots with how the data is returned from the Zap step.
+14In the Zap trigger DATA OUT, Excel is returning the “visible” value for the cell, not the formula value.
The URL would need to be in another cell to be used in Zap action steps.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
