Torx's Mind
Random IT stuff that 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(A2,SEARCH(".",A2)-1)
3
Server2.domain.domain.com
Server2
=LEFT(A3,SEARCH(".",A3)-1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment