Navigation: Reference > Transforms >
Replace text in 1 or more columns.
•Check the column(s) you wish to transform.
•Choose whether to use text or Regular expression matching.
•In Replace put the text you want to replace.
•In With put the text you want to replace it with.
You can turn 0123456789 into (+44) 1234 56789 using a Regular expression: