ExcelHeroThe SUBSTITUTE function
Replaces one piece of text with another.
In German Excel: WECHSELN
How to write it
=SUBSTITUTE(text, old_text, new_text, [instance_num])- text
- The text.
- old_text
- What to replace.
- new_text
- What to put instead.
- instance_num
- Optional. Only replace this occurrence.
💡 Use "" as new_text to delete something.
Try it
Replace the dashes in the code C2 with spaces.
A
B
C
D
1
Full name
City
Code
Clean
2
maya lopez
berlin
TS-1042-BLU
3
LEO KING
paris
HD-0077-RED
4
sam o’neil
Rome
MG-3150-GRN
=SUBSTITUTE(text, old, new).