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

It may be easier to use autofilter to fix the values. Turn on the autofilter
and select Custom Contains 3GPP

This will hide all the rows not containing the string. Next put a common
replacement in and un-used cell, copy it, and paste over the filtered data.

The paste will fix only the visible cells and leave the hidden ones alone.
--
Gary's Student


"Die_Another_Day" wrote:

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

I'm not sure this is much better than the klugy formula I'm already
using. I thought for sure that there was a function to return a partial
match. I just can't find it.

Die_Another_Day