Google Spreadsheet Post #1447
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Cassidy Price (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/OKEPzLavo8M)
Extract partial string from one cell to another
Yogi Anand, D.Eng, P.E. ANAND Enterprises LLC -- Rochester Hills MI www.energyefficientbuild.com. Dec-26, 2013
question by Cassidy Price (http://productforums.google.com/forum/?zx=e80jmfn2nptg#!category-topic/docs/spreadsheets/OKEPzLavo8M)
Extract partial string from one cell to another
I want to extract the domain from a list of urls from one column to another. For example;
I want to take this url from column A, e.g.
and extract only the domain name to column B, e.g
So for example, if I have a list of urls in column A:
I would end up with a list of domains in column B:
Can this be done? I've been trying to figure out a way to use regular expressions to accomplish this but I'm stumped. Thanks for any help!
--------------------------------------------------------------------------------------------------------------------------------------------
No comments:
Post a Comment