Excel Forum

Excel Magic Trick 332: Insert Text with REPLACE function

Insert Text into Test String with REPLACE function See how to insert a part of product ID into a longer product ID to achieve the corrected product ID. See the REPLACE, VLOOKUP and FIND functions in one formula.

Got a Question? Ask it Here in the Forum.