vba replace

' Replace into string
Sub TestMe()
    Debug.Print Replace("a,B,c,d,e", ",", "-")         'a,B,c,d,e -> a-B-c-d-e
    Debug.Print Replace("Mr XXX", "XXX", "Bond")       'Mr XXX -> Mr Bond
    Debug.Print Replace("a,b,c,d,e", ",", "-", 3, 2)   'a,B,c,d,e -> b-c-d,e
End Sub

View another examples Add Own solution

4.11

English Tips 115 points

                                    'VBA function to replace a substring... if it exists in the full
'string. Checking to see if it exists is very quick. Replacing is
'slow by comparison. So it is wise to check first:

Function IfInReplace$(s$, substr1$, replacement$, Optional CaseSensitivity = vbTextCompare)
    If InStr(1, s, substr1, CaseSensitivity) Then s = Replace(s, substr1, replacement, , , CaseSensitivity)
    IfInReplace = s
End Function

'---------------------------------------------------------------------------------------------------

MsgBox IfInReplace(&quot;abc123def&quot;, &quot;123&quot;, &quot;&quot;)    '&lt;--displays: abcdef

Thank you! 9

4.11 (9 Votes)

3.2

Laura Lee Williams-May 105 points

                                    'VBA function to make multiple replacements in a template string:

Function TemplateReplace$(template$, ParamArray replacements())
    Dim c&amp;, s$, t$, e
    s = template
    For Each e In replacements
        c = c + 1
        t = &quot;|%&quot; &amp; c &amp; &quot;|&quot;
        If InStrB(e, &quot;~~&quot;) Then e = Replace(e, &quot;~~&quot;, Chr(34))
        If InStrB(s, t) Then s = Replace(s, t, e)
    Next
    TemplateReplace = s
End Function

'--------------------------------------------------------------------

Const TEMPLATE = &quot;SELECT * FROM |%1| WHERE (survived = |%2|)&quot;
MsgBox TemplateReplace$(TEMPLATE, &quot;titanic&quot;, &quot;~~true~~&quot;)

'Displays: SELECT * FROM titanic WHERE (survived = &quot;true&quot;)

Thank you! 5

3.2 (5 Votes)

Are there any code examples left?

Find Add Code snippet

New code examples in category VBA

VBA 2022-03-27 20:55:02 excel vba check if all substrings in list are in string
VBA 2022-03-27 20:40:39 excel vba set cell value to empty
VBA 2022-03-27 17:05:52 vba simple quote
VBA 2022-03-27 14:30:19 textbox find and replace vb
VBA 2022-03-27 09:10:21 nested if else in vb.net
VBA 2022-03-27 09:10:09 excel vba string to bits
VBA 2022-03-25 02:00:15 vba verticalalignment
VBA 2022-03-24 12:20:06 Excel web scraping
VBA 2022-03-24 10:11:00 excel vba BitToLong
VBA 2022-03-21 18:00:05 excel vba save file txt

Create a Free Account

Unlock the power of data and AI by diving into Python, ChatGPT, SQL, Power BI, and beyond.

Develop soft skills on BrainApps

Complete the IQ Test

Relative searches

vba replace with values vba replace string in column excel vba replace string vba word replace vba excel replace text in string excel vba replace character in string vba access replace ' replace vba exemplo vba replace substring vba replacement vba replace part of string excel vba replace string in cell replace in vba replace text vba vba replace function example replace vba syntax replaceall in vba replace in vba excel What will replace VBA replace . with , vba excel replace . with , vba replace vba example excel vba replace part of string vba replace a text from string VBA replace ' how to replace string cells in excel vba vba replace vbcrlf vba substitute vs replace what will replace vba? excel vba find and replace text within cells vba str replace how to find and replace in excel vba substitute vba find and replace excel vba excel vba string replace vba excel replace in string vba replace in string vba find and replace vba replace all in string excel vba find and replace vba replace function vba code to replace how to search and replace in excel with vba str replace vba replace all occurrences of a specific character in a string excel vba replace all occurrences of a character in a string excel vba function to replace characters in vba Replace(Me.txtFare.Text, ".", "") vba vba replace string in template excel vba replace text vba replace string in string vba string change character excel vba replace char vba substitute string string replace vba visual basic replace text with number replace value in vba replaceing a character in vba replace values in vba REPLACE INVBA vba replace character in string excel vba find and replace text in string vba replace all vba find replace string vba replace text vba code to replace a specific character in string excel vga string substitute excel vga string substitute occurancies excel vga string substituteoccurancies excel vga string replace occurancies replace text macro sobstitute string vba excel replace characters from string vba excel vba replace text in string vba replace character vba replace char with char vba replace " vba replaceall substiture vba replace vba VBA.Replace is not declare vba replace string excel vba replace function vba find and replace in string vba replace all occurrences of in string vba string replace character vba excel replace string vba excel how to replace part of a string replace() vba excel vba replace excel vba replace / with - vba search replace in string how to find and replace a single letter in excel vba replace a substring using vba excel macro replace text with symbol vba substitute vba strreplace vba excel replace replace function syntax in vba replace charater in stringn vba replace string function in vba excel replace function vba replace method with example in vba replace part of string vba vba replace characters from string excel vba sql query replace function vba search and replace string replacing phonetics in excel macros vba rpelace i string string replace excel vba vba string replace substitute vba string concat in excel replace function in vba regexp vba replace replace function in vba vba replace part of a string excel-vba replace part of a string excelvba replace part of a string excel vba replace part of a string excel vba if a string contains a substring replace it excel-vba replaceall in string excelvba replaceall in string excel vba replaceall in string

vba replace

Welcome Back!

Create a Free Account