URL convert

[Forestq]

Hi,

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 Seminars | Excel Products"

For i = 2 To LastRow
.Range("CV" & i).Value = url(.Range("CV" & i))
.Range("CW" & i).Value = url(.Range("CW" & i))
Next i

How to add "if condition" that check me that the value if it is hyperlink or it is value - and if it`s hyperlink, then run me my code if not leave it.