Sorry for the confusing title, I will try my best to make this clearer. I have a sheet with cells like this:
Cell A1: hat cat dog house www.url.com/page1 house kitten <monkey> www.url.com/pagexxxxxxx fish hotel
Cell A2: office door window desk www.url.com/page2 mouse table <monkey> www.url.com/pageyyyyyyy dog chain
What I need to do is have the first text string which starts with "www." in the cell is kept and all the rest deleted. It would look like this:
Cell A1: www.url.com/page1
Cell A2: www.url.com/page2
Is there a formula I can run to do this or would that have to be a macro of some type?
Bookmarks