TOTT

Handy Excel Formulas

Strip hostname off of hostname and FQDN in B1
=LEFT(B1,FIND(".",B1,5)-1)

Strip hostname off of hostname and FQDN in A1 when there is a leading couple of nonsense characters
=LEFT(RIGHT(A1,LEN(A1)-2),FIND(".",RIGHT(A1,LEN(A1)-2),5)-1)

Strip hostname off of hostname and FQDN in A1 when there is a leading couple of nonsense characters v- Another way.
=RIGHT(LEFT(A1,FIND(".",A1,5)-1),LEN(LEFT(A1,FIND(".",A1,5)-3)))