For me personally,these new text functions will be great for working with IP address, MAC address, FQDN, and URL

There are already ugly, kludgey ways of doing it (or doing it outside of Excel altogether) but this will be faster and more elegant