Formulas to remove multiple types of characters from cell text.(Microsoft Excel)


Japanese version.

The SUBSTITUTE function can be used to delete certain text in a cell by replacing it with blanks, but it can only target one type of text. This article will show you how to target multiple types of text.


It is possible to perform the SUBSTITUTE function by overlapping only the target type, but in Excel, which reflects newer features such as Microsoft365, this can be accomplished without overlapping the SUBSTITUTE function.
The REDUCE and LAMBDA functions are used for formulas.

=REDUCE(Text,Deletion Target(Cell range),LAMBDA(r,s,SUBSTITUTE(r,s,"")))



Tips. Others.(Microsoft Excel)