Find and Replace with Wild Cards

  • Thread starter Thread starter Rand Hager
  • Start date Start date
R

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
 
You could use the SUBSTITUTE function, and specify the instance number:

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