REPLACE

REPLACE([Name], 'Suit', 'Helmet')

Syntax

REPLACE(text expression, text to be replaced, replacement)

Text function which replaces text to be replaced in an income text expression with its replacement. REPLACE('Hulk', 'Hu', 'Wa') = 'Walk'.

text expression: Text created using text functions, text fields or constants.