Home 
Search 
Today's Posts 
#1




Help With Searching For Strings In Part Numbers
I am using Microsoft Excel 2000.
I have a spreadsheet with many, many part numbers in Column A. There are no duplicate part numbers. What I want to do is create a formula that will put an "X" in Column B of a part number if one of the following strings is included in the part numbers. (A part number will not have more than one of these strings.) 1K0PR 1K0SI 1K0VA 1K0VR For instance, if the part number were 1C014C014A0000D006, then there would be no "X" in Column B because none of the above strings is embedded in the part number. On the other hand, if the part number were 1Z071K0VRKV0GS000AUTOM then there should be an "X" in column B because it includes the string "1K0VR". So, I built the following formula (which obviously does not work!!): =IF(ISERR(SEARCH(OR("1K0PR","1K0SI","1K0VA","1K0VR "),A1,1)),"","X") What am I doing wrong?  tb 
#2




Help With Searching For Strings In Part Numbers
Hi,
Am Tue, 21 Jun 2011 14:18:01 +0000 (UTC) schrieb tb: What I want to do is create a formula that will put an "X" in Column B of a part number if one of the following strings is included in the part numbers. (A part number will not have more than one of these strings.) 1K0PR 1K0SI 1K0VA 1K0VR For instance, if the part number were 1C014C014A0000D006, then there would be no "X" in Column B because none of the above strings is embedded in the part number. On the other hand, if the part number were 1Z071K0VRKV0GS000AUTOM then there should be an "X" in column B because it includes the string "1K0VR". try: =IF(COUNT(SEARCH({"1K0PR";"1K0SI";"1K0VA";"1K0VR"} ,A1))0,"X","") Regards Claus Busch  Win XP PRof SP2 / Vista Ultimate SP2 Office 2003 SP2 /2007 Ultimate SP2 
#3




Help With Searching For Strings In Part Numbers
On Jun 21, 9:18*am, "tb" wrote:
I am using Microsoft Excel 2000. I have a spreadsheet with many, many part numbers in Column A. *There are no duplicate part numbers. What I want to do is create a formula that will put an "X" in Column B of a part number if one of the following strings is included in the part numbers. *(A part number will not have more than one of these strings.) 1K0PR 1K0SI 1K0VA 1K0VR For instance, if the part number were 1C014C014A0000D006, then there would be no "X" in Column B because none of the above strings is embedded in the part number. *On the other hand, if the part number were 1Z071K0VRKV0GS000AUTOM then there should be an "X" in column B because it includes the string "1K0VR". So, I built the following formula (which obviously does not work!!): =IF(ISERR(SEARCH(OR("1K0PR","1K0SI","1K0VA","1K0VR "),A1,1)),"","X") What am I doing wrong?  tb '=IF(COUNT(SEARCH({"1KOVR","1KOSI"},B28)),"X","") 
#4




Help With Searching For Strings In Part Numbers
On 6/21/2011 at 9:43:09 AM Claus Busch wrote:
=IF(COUNT(SEARCH({"1K0PR";"1K0SI";"1K0VA";"1K0VR"} ,A1))0,"X","") Works great! Thanks.  tb 
Reply 
Thread Tools  Search this Thread 
Display Modes  


Similar Threads  
Thread  Forum  
Searching for strings in a column  Excel Worksheet Functions  
vba searching for strings in multiple worksheets  Excel Discussion (Misc queries)  
Searching for codes in text strings  Excel Worksheet Functions  
searching for multiple text strings  Excel Discussion (Misc queries)  
Searching for Substrings Within Strings  Excel Discussion (Misc queries) 