An alternative to Concatenate, this function substitutes keywords with replacement text in a string. The keywords are the text '{1}' through '{11}' representing the eight replacment strings. The keywords do not need to be in any particular order.

The syntax of the function is:

=StringSub(String, Subs1, Subs2, Subs3, Subs4, Subs5, Subs6, Subs7, Subs8, Subs9, Subs10, Subs11)


String is the text with keywords to replace.

Subs1..n is the replacement text. All Subs are optional. For example =StringSub("abc") returns "abc".


=StringSub("{1} picked a {3} of {2}.", "Peter Piper", "pickled peppers", "peck") returns "Peter Piper picked a peck of pickled peppers."

in reality, the arguments would most likely be references to cells:

=StringSub("{1} picked a {3} of {2}.",D3,E3,F3)

Created with the Personal Edition of HelpNDoc: Create help files for the Qt Help Framework