Ok this should be easy... I've got a 4k plus line spreadsheets with
multiple users that are entering in a parameter that SHOULD have been
the same. However every user has a different appendage to the
parameter. I'm trying to use an if statement to parse the expected
value so things show up correctly in my Pivot table. anyhow here is the
formula that I got to work:

=IF(ISERROR(SEARCH("3GPP",D2,1)),"HSDPA","3GPP")

can someone please help me find a way to see if the cell contains the
text? this works but it is very ugly.

TIA

Die_Another_Day