if in field, I have value with hyperlink. I'm removing the value and put it just hyperlink
example: A1 = "MREXCEL"
where MREXCEL is link into "MrExcel.com | Excel Resources | Excel Seminars | Excel Products"
after macro I get only the link: A1 = "MrExcel.com | Excel Resources | Excel...