Complicated if formula with searching text

[currybai]

I have the following formula

=IF(ISNUMBER(SEARCH("verizon",A2)),"verizon",IF(ISNUMBER(SEARCH("sprint",A2)),"sprint",IF(ISNUMBER(SEARCH("tmobile",A2)),"tmobile","")))


Instead of searching the entire text of A2, is there a way to say search first 5 letters because some text strings look like Verizon-Users-Sprint-Profile but that should really be verizon. And the format is not always text-text-, sometimes its text text or text : text so it varies.

 

[Domenic]

Maybe...

=INDEX({"verizon","sprint","tmobile"},MATCH(LEFT(A2,5)&"*",{"verizon","sprint","tmobile"},0))

 

[Peter_SSs]

Given the structure of the original formula indicates that a null string is to be returned if A2 doesn't start with any of the 3 words, and assuming Excel 2007+, then maybe this modification of Domenic's formula.

=IFERROR(INDEX({"verizon","sprint","tmobile"},MATCH(LEFT(A2,5)&"*",{"verizon","sprint","tmobile"},0)),"")

 

[currybai]

Given the structure of the original formula indicates that a null string is to be returned if A2 doesn't start with any of the 3 words, and assuming Excel 2007+, then maybe this modification of Domenic's formula.

=IFERROR(INDEX({"verizon","sprint","tmobile"},MATCH(LEFT(A2,5)&"*",{"verizon","sprint","tmobile"},0)),"")

This works perfect. But now for everything else that is not in those 3 words, how do I say take the first word after Client Data. Ex:
Client Data - Nextel (Phone)
Client Data - Bob (Phone)
Client Data - Akame (Phone)

I want the Nextel, Bob, and Akame part.

Then if not those, then how do I layer in just take the first word or few words before a space and parenthesis.

Ex:

Microsoft (software)
Google (internet)
Yahoo.com Portal (Internet

So I want, microsoft, google, and yahoo.com portal.

 

[Peter_SSs]

If the following does not satisfy your requirements, could you give a set of sample data (say 10-15 rows) that demonstrates the whole variety of data you have and also give the expected results for each of those rows?

Excel Workbook
	A	B
2	Verizon-Users-Sprint-Profile	verizon
3	Client Data - Nextel (Phone)	Nextel
4	Client Data - Bob (Phone)	Bob
5	Google (internet)	Google
6	Yahoo.com Portal (Internet)	Yahoo.com Portal
Search text