Hello,

I've got the following formula:

=IF(LEFT(G2,1)="7","Mobile","")

Which basically tells me if the number in G2 starts with a 7, it must be a mobile number.

BUT I need to insert another criteria which is, if cell I2 (description column) includes the words "personal" or "PNS" then its a personal number.

I cant seem to get the formula to work with a FIND insert, could anyone help please?

Many many thanks