Sequoia 15.7.2 in Numbers I am not able to edit the url/s that I have listed in a column. My list of addresses begin with https:// That is what I want to delete in every row. I would like to change all at once but will do one by one if I need to.
iMac (2017 – 2020)
It isn't quite clear what you're trying to. Are you saying you have something like:
and you want:
If you want to change 'in place', then a simple Find and Replace will do the job. Edit -> Find...:
This will replace all occurrences of 'https://' with an empty string.
If you want to retain the original URL and just extract the hostname and/or path from the URL, then you need an adjacent column with some text functions to strip the protocol:
Formula in F2 is:
=TEXTAFTER(E2,"https://",1)
which returns all the text after 'https://' (note this may be more complicated with more complex URLs, but I can't see what you're working with.
It isn't quite clear what you're trying to. Are you saying you have something like:
and you want:
If you want to change 'in place', then a simple Find and Replace will do the job. Edit -> Find...:
This will replace all occurrences of 'https://' with an empty string.
If you want to retain the original URL and just extract the hostname and/or path from the URL, then you need an adjacent column with some text functions to strip the protocol:
Formula in F2 is:
=TEXTAFTER(E2,"https://",1)
which returns all the text after 'https://' (note this may be more complicated with more complex URLs, but I can't see what you're working with.
Remove 'https://' from URLs in Numbers column
