First, set up a model cell with the replacement formatting. Next, press Ctrl+H to launch the Find and Replace dialog. There, define both the Find What and Replace With formatting by clicking "Choose ...
Microsoft Excel for analysts skills include Power Query to trim spaces and merge columns, so you automate cleaning steps and ...