Good to all and to all.
I am looking for ways to be able to remove special characters from multiple cells in excel.
For example, from A2:A50 to replace the special characters in the selected cells.
Example:
H&*O^&@LA --> HELLO
The function should not initially be executed through a macro.
How could I then replace the special characters?
I have the idea to do it with a macro, for example using a loop with a string and doing a replacement in each cell but I'm not sure how I could do it in the sheet without a macro.
I have tried with : =REPLACE("XYZ123",4,3,"456"), but replace asks for the positions to be replaced. In this case I would not know which positions to use.
PS: Using an extension is not a solution.
Thanks.