Count and Extract

[How_Do_I]

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 Workbook
	A	B	C
1	Child Folder: Cycling		3
2	Elham Valley Cycle Ride.pdf		Cycling
3	Giro 2014.pdf		Walks
4	Miner's Way Cycle Map.pdf		War
5	Child Folder: Walks
6	Frontline Britain Trail Map.pdf
7
8	Child Folder: War
9	Bombing London - Unexploded Bombs.pdf
10	fortitude.pdf
Sheet1

 

[Aladin Akyurek]

Thank you Aladin...

You are welcome.