Replace several substrings to several substrings in single string using vba (excel)

Question

please tell me whether it is possible to perform a replacement in a string that combines several different substitutions using VBA (excel)?

For example:

text = Replace(text, find1, res1)
text = Replace(text, find2, res2)

Real example:

text = Replace(text, "&nbsp;", " ")
text = Replace(text, "&amp;", "&")
text = Replace(text, "&lt", "<")

Maybe regexp?

Yes, you can do exactly like your examples show -- use three statements. Unless there are more details that you left out... — Wayne G. Dunn
– Wayne G. Dunn, Commented Nov 19, 2017 at 15:29

Gary's Student · Accepted Answer · 2017-11-19 16:05:33Z

1

Nest them:

Text = Replace(Replace(Replace(Text, "&nbsp;", " "), "&amp;", "&"), "&lt", "<")

answered Nov 19, 2017 at 16:05

Gary's Student

96.9k10 gold badges66 silver badges104 bronze badges

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

1 Answer 1