You’re offline. This is a read only version of the page.
19
So I have a data table, and in this there are numbers. Ex: 1203123. However, some of these numbers have "-", Ex: 120312-1230123.
I am trying to use the find and replace function to find all "-" and replace it with a blank space. However, when trying to do this I am told that the text I am trying to test with is an Invalid Value.
Hi @KaiHalpin !
Try this:
So I am trying to find - and replace it with %''%.
Input:
Output:
If you need to replace it with a space enclose the single quotes with a space in % signs. Like this: %' '%
Then output will be:
I hope this helps.
Share
Report
All responses (
Answers (
