Okay here we go.

I need to create a Conditional Formula that

1. Identifies the words i.e. Single Adult or Single Adult + 1 Child and then
returns the number 1 or 2.

This is so I can count the people. With me so far.

Here is the issue

I have 50 Different Family Compliments (Single Adult) to do this on and need
a formula that can handle it.

HELP - I can e-mail the spreadsheet if you need it.