Removing HTML tags (specifically <p> tags)

Hi!


I'm new here. This would be my first post. I am in dire need of some help with removing HTML tags from a CSV file. I have about 3600 entries to modify. I used:

Sub RemoveTags()
Dim r As Range
Selection.NumberFormat = "@"  'set cells to text numberformat
With CreateObject("vbscript.regexp")
  .Pattern = "\<.*?\>"
  .Global = True
  For Each r In Selection
    r.Value = .Replace(r.Value, "")
  Next r
End With
End Sub

But that left me with about 880 entries with:

<p class="MsoNormal" style="margin-bottom:0in;margin-bottom:.0001pt;line-height:normal">

I also tried find and replace using <*> for find and a empty replace field but I get the "Formula is too long" error message.


I'm pretty new to VBA so any help is appreciated!

Cross posted here!