Substitute Excel Multiple. Use replace when you want to replace any text that occurs in a specific location in a text string. Substitutes new text for old text in a text string.
Set replacerng application inputbox replace range xtitledid type 8 application screenupdating false for each rng in replacerng columns 1 cells inputrng replace what rng value replacement rng offset 0 1 value next application screenupdating false end sub. Excel substitute this formula is actually using the substitute function to replace multiple items. Substitutes new text for old text in a text string.
This article describes the formula syntax and usage of the substitute function in microsoft excel.
Substitute substitute a4 1 1 result. Add columns until all hyphens are dealt with. Use replace when you want to replace any text that occurs in a specific location in a text string. Substitute a1 you can then copy this across to c1 d1 e1 etc.
