Split and merge data in URLs

re: Split and merge data in URLs

Mantvydas — Wed, 30 May 2012 18:51:49 GMT

This example is an oversimplified version of what you get in real life. Normally, you don't get URLs as a cell contents, normally you get them as URLs inside the hyperlink. And in this latter case you're doomed: Excel can neither Find, nor Replace hyperlinks. Hopefully this is going to be fixed in Excel 2012.

re: Split and merge data in URLs

Stacey Armstrong — Thu, 17 May 2012 16:42:42 GMT

Thanks Ben,

Yes, the DATE function will work as well. Thanks for pointing that out.

Stacey

re: Split and merge data in URLs

Ben Niebuhr — Thu, 17 May 2012 16:27:16 GMT

Great post, Stacey, I always forget about the power of text to columns. Or maybe I just default to formula acrobatics.

I would suggest the use of =DATE(F2,D2,E2) in place of the concatenate function. This puts the data already in the correct format, and type.

I always enjoy these tips.

Ben