I have a spread sheet with FQDN's in one column. What I need to do is separate it so that I only have the short name.
So this is currently in column1
I need it to be....
Is there a way to automate this to make it easier to do?