Remove words in Excel row using an Array object

[dwalker97]

Hi

I am currently trying to remove the words 'Limited' and 'Express' from multiple rows in an input table. 

I have stored the two strings in an Array. I have a condition that picks up on whether a row in my table contains either of the Array objects, but I am unsure as to what the next step is in the 'Yes' part of my condition. I would like to remove 'Limited' and/or 'Express' from each row.

I have messed around with Variables and Compose but haven't seemed to get anything working myself.

Any suggestions are appreciated.

Thanks

Daragh

[sumurthy]

Are you trying to remove words from specific columns or multiple/all columns or just filter the whole row if one or many columns have these words?

[dwalker97]

Hi, I am trying to remove words from the same column. This column is called 'Name'.

Thanks!