Friday, August 21, 2015

Get Short Name from FQDN

Got a list of FQDN names and just need the short name?  use left and search.  See my example formula used in B2 and B3


A
B
1 FQDN Short Name
2 Server1.domain.com Server1 =LEFT(B2,SEARCH(".",B2)-1)
3 Server2.domain.domain.com Server2 =LEFT(B3,SEARCH(".",B3)-1)

No comments: