Hi there,
I have an Excel sheet with several columns of data, each containing the link to a website. To the far right of this data, I have a column called "Official Source" in which I'd like to copy over any website links containing the phrase "sec.gov" (if there are any, if not than leave the cell blank).
For example, if I have the following data in my sheet:
Column A Column B Column C
www.wsj.com www.nytimes.com sec.gov/Ar
Than I would want the last source to move to column D -
Column A Column B Column C Column D
www.wsj.com www.nytimes.com sec.gov/Ar
Any ideas how to do this?
Bookmarks