Quote:
Originally Posted by Marcia
What I do is to select all the cells that need editing>Ctrl F>type '-' in the Find What box>click on the Replace With>Replace All
|
That, however, would remove all the hyphens...
Judging by the posted example, one needs to Find ' - ' and replace with ' '. Or, as per the OP's request, a formula could be used:
=SUBSTITUTE(A1, " - "," ")