Etaf pretty much nailed it -- this would be the whole thing
put this in B2 and copy it down....![]()
=IF(LEFT(A2,2)="MC","Multi Carrier",IF(LEFT(A2,9)="MetChoice","Choice",""))
Etaf pretty much nailed it -- this would be the whole thing
put this in B2 and copy it down....![]()
=IF(LEFT(A2,2)="MC","Multi Carrier",IF(LEFT(A2,9)="MetChoice","Choice",""))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks