MISSION IMPOSSIBLE: Delimitor? Left Right Function??

[pwall1115]

Hey Guys,

Any help on this would be much appreciated. I have a report which has 10,000 campaigns that need to have their Type identified. Campaign Types are either 1. ABC or 2. Network

Campaign names look like this:
Example A: 1-80601-BTR Test campaign Feb 2012-ROE-Various-Feb12-ABC (28877)
OR/
Example B: 2-15737-AHS - R & Rabc KM Campaign-ROE-Various-Feb_Mar12 (2625557)

If the campaign ends with "-ABC" (before unique ID numbers) then the Type is "ABC". If it doesn't end with "-ABC" then the type is "Network". I'm looking for a function that I can just drag down to populate the entire Type column so I don't have to do all 10,000 one by one. I attached an excel as an example that makes it clearer. Any help would be much appreciated!! This forum has never let me down!! Thanks!!!!Example Excel.xlsx

[Jakobshavn]

With data in column A, in B1 enter:

=IF(LEN(A1)=LEN(SUBSTITUTE(A1,"-ABC ","")),"Network","ABC")

[Ace_XL]

Maybe..

Please Login or Register  to view this content.

[pwall1115]

Wow thank you so much to the both of you - both functions worked!! If you don't mind, can you explain the logic behind the functions you've provided - I'm trying to understand and learn this so I can improve my excel skills for the future.

Much appreciation and gratitude!

[Ace_XL]

The SEARCH function simply searches for text "ABC (*)" and if it finds it it returns a number. The * represents wildcard charcatres
In case of a match, the ISNUMBER turns TRUE and hence the result is "ABC", else it is "Network"

[pwall1115]

AWESOME, thank you : )