MS Excel | vba excel substitute
ThisExceltutorialexplainshowtousetheExcelSUBSTITUTEfunctionwithsyntaxandexamples.DescriptionTheMicrosoftExcelSUBSTITUTEfunctionreplacesasetofcharacterswithanother.TheSUBSTITUTEfunctionisabuilt-infunctioninExcelthatiscategorizedasaString/TextFunction.Itcanbeusedasaworksheetfunction(WS)inExcel.Asaworksheetfunction,theSUBSTITUTEfunctioncanbeenteredaspartofaformulainacellofaworksheet.SyntaxThesyntaxfortheSUBSTITUTEfunctioninMicrosoftExcelis:SUBSTITUTE(text,old_text,new_text,[nth_appearance])Para...
This Excel tutorial explains how to use the Excel SUBSTITUTE function with syntax and examples.
DescriptionThe Microsoft Excel SUBSTITUTE function replaces a set of characters with another.
The SUBSTITUTE function is a built-in function in Excel that is categorized as a String/Text Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the SUBSTITUTE function can be entered as part of a formula in a cell of a worksheet.
SyntaxThe syntax for the SUBSTITUTE function in Microsoft Excel is:
SUBSTITUTE( text, old_text, new_text, [nth_appearance] ) Parameters or Arguments text The original string to use to perform the substitution. old_text The existing characters to replace. new_text The new characters to replace old_text with. nth_appearance Optional. It is the nth appearance of old_text that you wish to replace. If this parameter is omitted, then every occurrence of old...取得本站獨家住宿推薦 15%OFF 訂房優惠
WorksheetFunction.Replace 方法(Excel)
MsgBox "The current string is: " & strCurrent ' Replace "cd" with "-". ... Replace _ (Arg1:=strCurrent, Arg2:=3, _ Arg3:=2, Arg4:="-") ' Notify user and display replaced string. ... 有關於Office VBA 或這份文件的