Thursday, December 26, 2013

yogi_Extract Partial String (ending at .com) From Cells Of One Column To Cells Of Another Columns

                                          Google Spreadsheet   Post  #1447
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   Dec-26, 2013
question by Cassidy Price (!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!