Need Macro remove hyperlink text <a [SOLVED]

Guys Need help to create macro that will remove all hypertext formatting in Column A.

Example:
In Column A
<a href="/Menu_Object.aspx?objID=24527" target="_blank">Only want this text</a>

result should be:

Only want this text

Use this:

Sub Hypertext()
Cells.Replace What:="<*>", Replacement:="", LookAt:=xlPart, SearchOrder _
:=xlByRows, MatchCase:=False, SearchFormat:=False, ReplaceFormat:=False
End Sub

Hope this works for you..

Thanks for confirming!

< ----- Please click the little star * next to add reputation if my post helps you******************