Hi,
I have a column containing names of towns, each cell has the name of the town and a .html link. I would like to remove all the .html links. Is there an easy way to do this? So far I know that I can remove “.html” from all cells but the rest of the link won’t be deleted.
An example of the column:
- Aberdeen aberdeen.html
- Aberdeen Queens Links aberdeen.html
- Aberdeen Union Square aberdeen.html
- Accrington accrington.html
- Aldershot woking.html
- Altrincham altrincham.html
- Andover salisbury.html
I am trying to delete the “aberdeen.html”, “accrington.html”, “working.html”, and so on, part of the cell.
Thanks!