Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

WorksheetFunction.Substitute Method (Excel)

Published: July 16, 2012

Substitutes new_text for old_text in a text string. Use SUBSTITUTE when you want to replace specific text in a text string; use REPLACE when you want to replace any text that occurs in a specific location in a text string.

expression .Substitute(Arg1, Arg2, Arg3, Arg4)

expression A variable that represents a WorksheetFunction object.

Parameters

Name

Required/Optional

Data Type

Description

Arg1

Required

String

Text - the text or the reference to a cell containing text for which you want to substitute characters.

Arg2

Required

String

Old_text - the text you want to replace.

Arg3

Required

String

New_text - the text you want to replace old_text with.

Arg4

Optional

Variant

Instance_num - specifies which occurrence of old_text you want to replace with new_text. If you specify instance_num, only that instance of old_text is replaced. Otherwise, every occurrence of old_text in text is changed to new_text.

Return Value

String

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.