You previously answered a part of my question, but I am looking to modify this behavior in multiple rows of column A so I don't want to manually correct it.
In A2 I have:
In B2 I use concatenate
This creates the link I need, and returns the same text that is in A2, but I want just the first portion without the/index.html to be viewable.
I do not want the
"/index.html" to show