How can I use excel Replace <*> in excel vba like in excel? (regular expressions)

Question

If you want to delete html tags in excel one way is to use the replace function. I search for "<*>" and replace it by "". So I just delete every html tag. Excel VBA also has a replace function but it is far more stupid. If I write:

temp2 = Replace(temp2, "<*>", "")

It doesn't interpret "< * >" as a regular expression. It only replace 1:1 the string "<*>". How can I use the replace function in VBA like I do in Excel?

There's also the ability to use regular expressions in vba. See stackoverflow.com/questions/22542834/… — MiguelH
– MiguelH, Commented Sep 2, 2015 at 10:42
If you would have recorded a macro, you would have got your answer... ;) — Siddharth Rout
– Siddharth Rout, Commented Sep 2, 2015 at 10:43

Wiktor Stribiżew · Accepted Answer · 2015-09-02 10:37:01Z

4

To search and replace all cells in the active sheet, you need to use something like:

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

Note that you can indicate the cell directly in the beginning: Cells(2,1). (to only replace in the A2 cell.

answered Sep 2, 2015 at 10:37

Wiktor Stribiżew

631k41 gold badges502 silver badges632 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

Flex Texmex Over a year ago

yes thumb up ;) problem is my question is marked as dublicat but the other similiar question doesn't have your good answere ;)

Wiktor Stribiżew Over a year ago

Your question is not marked as a duplicate. At least at this moment.

Collectives™ on Stack Overflow

How can I use excel Replace <*> in excel vba like in excel? (regular expressions)

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related