Looking for a formula to obtain data from WHOIS lookup and populate a cell

[aindependentvariable]

I have a spreadsheet where I manually enter URL's and/or an IP addresses which I later need to manually do a WHOIS lookup to obtain the abuse or admin email. I tried using a macro to do this but the only one I found is specifically written to use a particular WHOIS site which masks the email addresses as images, which wont work for my needs. I need the text. That macro is found here https://www.datanumen.com/blogs/create-whois-lookup-tool-via-excel-vba/ I've contacted the site but they said they won't offer any support on it.

Is this possible to do with a formula rather than a macro? Can anyone help me modify this macro to work for my needs or point me to one that will?