Find and Replace with Wild Cards

[Rand Hager]

How do I replace only the first occurence of a Find match
in a string or cell if that string is repeated without
manually replaceing each one?
for ex.
IN 31-1012101-3
FIND 101
REPLACE 102
RESULT 31-1022101-3

 

[Debra Dalgleish]

You could use the SUBSTITUTE function, and specify the instance number:

=SUBSTITUTE(B2,"101","102",1)