Easily change various fragments of your text values to any other ones you need by using the Replace Substrings feature in Substring Tools. The add-in finds the substrings you specify in your original column and creates a new one containing the modified values.
Pay attention to the following aspects:
Click the Substring Tools icon on the Ablebits Data tab and start the tool by selecting Replace Substrings:
Here is the tool pane to work with:
See an example:
The tool processes your data right after you click the Replace button. The resulting column appears on the right of the source one and the tool informs you about the work done:
Post a comment
Seen by everyone, do not publish license keys and sensitive personal info!