SharePoint Excel EncodeURL

Occasional Visitor


I am wondering how can I EncodeUrl cell in my excel sheet that is being stored in the SharePoint?

I know that this function is not available inside SharePoint, but is there any workaround?

I was thinking of maybe achieving this somehow in a way like, having a list of predefined values and their encoding reference code next to it and trying to iterate through the cell and if predefined values exist in the cell then replace them with encoding reference code.

Not sure if it is a good way to achieve that and if there is maybe anyone knows how it can be achieved in a Formula?



0 Replies