In the following how would I count the cells that contain "Child Folder" and then extract that cell less the words "Child Folder" please?
The returns I'm after are in cells C1:C4.
Excel WorkbookABC1Child Folder: Cycling32Elham Valley Cycle Ride.pdfCycling3Giro 2014.pdfWalks4Miner's Way Cycle...