Excel User Group
Microsoft Excel blogs, forums, files. Read, ask questions, provide answers.

Browse by Tags

  • Split and recombine data in URLs

    Issue: I have a list of URLs with their corresponding page views. The URLs include a section of the site and the date when the page was published. I'd like to calculate the total number of page views by site section and the total number of page views by publication date. I want to reduce the time it would take to manually enter this data into new columns. To save time, I plan on using the Text to Columns wizard and Concatenate function rather than a complex formula. Once you learn the steps,...
Copyright Excel User Group and the relevant contributors, 2010. All Trade Marks acknowledged. This site is a peer-to-peer site and NOT affiliated in any way to Microsoft Corp. All rights reserved.