Use LEFT and SUBSTITUTE extract specific octets from IP address Use LEFT to extract server name from FQDN
The examples below show how to extract a server name from Fully Qualified Domain Domain, how to extract server names from LDAP attribute name, how to extract specific octets from an IP address, how to extract text from inside specific characters and how to trim specific characters from the start or end on a cell contents. LEFT, RIGHT, MID and FIND are useful Excel functions to help you extract specific parts of text or numbers from a cell.
