Want to become an expert in VBA? So this is the right place for you. This blog mainly focus on teaching how to apply Visual Basic for Microsoft Excel. So improve the functionality of your excel workbooks with the aid of this blog. Also ask any questions you have regarding MS Excel and applying VBA. We are happy to assist you.

Replace string inside a string by another string

Dim s1,s2,s3 As String
s1 = "abcabcabc"
s2 = Replace(s1, "a", "b")
s3 = Replace(s1, "bc", "a")

You will get below answers

s2= bbcbbcbbc
s3= aaaaaa

Contact Form


Email *

Message *