Excel Formula

[Jknightt]

I need to create a formula that extracts the role/purpose of the server from the server name.

Example Server Names:
ttnetc10s13xth1
uk-bs-wr-1
ttnet-c3s12-wr2

In these examples, "XTH", "WR" and "WR" are the server roles. I would like to create a formula that examines the name and if the name contains "WR" then populate the field with WR. If the names contains "XTH" then populate the field with XTH. There will NEVER be a situation where a server name will contain 2 of the scenario's. The only issue is there are around 20 server role scenarios. I cannot file a "if contains" formula.

Any help would be greatly appreciated.

Thanks

 

[Diffy]

Say the server name is in A1, try this:

=if(isnumber(find("wr",A1,1)),"WR",if(isnumber(find("xth",A1,1)),"XTH",""))