SUBSTITUTE

Replace known text patterns while cleaning imported information.

Practical example

=SUBSTITUTE(A2, "-", " ")

Identify the source cells, apply the smallest reliable formula or tool, and test the result with changed data.