Add a backspace between to text value

[TarekIMEX]

Hello everyone, I'm looking to add a backspace between two text value.

Eg :

What I have

Value	Text Value
1	Question 1 - Question 2 - Question 3
2	Question 4 - Question 5 - Question 6
3	Question 7 - Question 8 - Question 9

What I want

Value	Text Value
1	Question 1 Question 2 Question 3
2	Question 4 Question 5 Question 6
3	Question 7 Question 8 Question 9

Thank you by advance.

[aatalai · Accepted solution]

@TarekIMEX not sure if you wanted it on new lines or just to delete the dash so put the m both in this workflow, hope it helps

[bgreedy]

You could use a formula tool to replace " - " with a new line

Replace([Text Value]," - ","
")