Identify Characters in a Cell then Delete the row

Hi,

Can anyone out there please help me?

I am not sure if the following can be automated through a Macro or not, but it would certainly save me loads of time if if could!

A B C D
1705 B001705-TU900-1 B001705-TU900-F1-1 49
1705 B001705-TU900-2 B001705-TU900-F2-2 207
1705 B001705-TU900-3 B001705-TU900-F3-3 244
1705 B001705-TUMTS-1 B001705-TUMTS-F1-1 366
1705 B001705-TUMTS-2 B001705-TUMTS-F2-2 23
1705 B001705-TUMTS-3 B001705-TUMTS-F2-3 182

What i need to do is identify "F2" within Column C (Characters 15 & 16) and then delete the row, so i end up with the following:

A B C D
1705 B001705-TU900-1 B001705-TU900-F1-1 49
1705 B001705-TU900-3 B001705-TU900-F3-3 244
1705 B001705-TUMTS-1 B001705-TUMTS-F1-1 366

Please help if this is possible so i can get hours of my life back again!

Thanks
Dave

Yes and Yes.....

Thank you...

Thanks Solus, ill give that a go and let you know how i get on

Hi Salus

Unfortunaly i get the below error?

---------------------------
Microsoft Visual Basic
---------------------------
Compile error:

For without Next
---------------------------
OK Help
---------------------------

Solus, your a star, thank you it works a treat

Hi Solus,

As usual my requirements have changed!!! I now i only want to delete Cell B, C and D rather than the entire row.

I tried the below but it doesnt seem to work? Can you help?

Sub DeleteDuplicates()

Dim l As Long
Dim lRow As Long

lRow = Range("C56635").End(xlUp).Row

For l = lRow To 1 Step -1

If Range("C" & l).Value Like "*-F2-*" Then
Range("C" & l).Range("B:D").Select
Selection.Delete Shift:=xlUp
End If

Next l

End Sub