Formula to identify text within a cell

[Glayva]

I have a list fo file paths in column A, eg:

• /may to october/latest news/parents and carers - january 2012 update?dm_i=LQE,OQTK,39545,1ZWGX,1
• /may to october/centre vacancies/admin officer?pSourceVersionId=-

I would like to create a table showing how many entries in the list contain certain elements of the file path - for example how many cells contain '/latest news/' and how many contain '/centre vacancies/'.

I was trying to run an IF statement saying 'if cell A2 contains 'centre vacancies' then put the phrase 'centre vacancies' in cell B2' and was then just going to create a pivot table. But my VBA is a bit rusty...

Please note - it's important to include the '/'s when looking up the text within the cell because (unfortunately) the text may appear in another part of the file path - i.e.

• /may to october/centre vacancies/centre vacancies admin officer?pSourceVersionId=-

Any help woudl be great - thanks.

[Bob Phillips]

Just use a formula, no VBA needed

=IF(ISNUMBER(FIND("/latest news/",A2)),"latest news","")

[Glayva]

Thanks Problem solved