Torx's Mind
Random IT Stuff I have picked up here and there.
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment