Is this possible to change any column entry of a google sheet as shown in the pictures? Example I want to change the above entries of Column C to the entries shown in the below picture. Please post me a way to do that anyhow.

Reputation: 1

How to manipulate data according to your criteria in google sheets?

Is this possible to change any column entry of a google sheet as shown in the pictures? Example

How data look like earlier

I want to change the above entries of Column C to the entries shown in the below picture.

How data look like after

Please post me a way to do that anyhow.

Upvotes: 0

Reputation: 1

try:

=INDEX(IFERROR(REGEXEXTRACT(A1:A, "^(?:https?:\/\/)?(?:www\.)?([^\/]+)")))

Upvotes: 1