So after doing some research I've found that you can simply hover over the link for some options..
for example:
https://www.ericasplumbing.com/plumb...al-springs-fl/
hover over the link and excel will give you edit options, click the pencil icon. there are two options, the top is the display tect where I could edit this to (for example):
www.ericasplumbing.com/
below that, is the actual url which will and should remain the same as the example states:
https://www.ericasplumbing.com/plumb...al-springs-fl/