Skip to main content

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

 

Hi @Rixin 

For us to have context, post screenshots with how the data is returned from the Zap step.


Hi @Troy Tessalone ,

 

Thank you for your respond.

Below are the screenshots. 

 

Thanks.

 

 


@Rixin

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.