I want to replace the breakline(new line) from a string with '|' character. I want to copy a list of numbers from Excel into an input box, so after that I can search those strings in a search bar.
I tried this but it's not working
='('& Replace('$(vTest)',chr(13)&chr(10),'|')&')'
Example:
1 2 3 4 5 I want to search all those numbers into a search box so I need to transform them into the following format: (1|2|3|4|5)
