Whats the best way to replace a group of text in a column with blanks?

[zenSMP]

Hi All,

As per title, whats the best way to replace a group of text in column with blank.

Example in the attached excel and photo below I would like to replace 3M/Nokia/Cisco in input with Blank and have it shown as output.

I understand formula, regex and find a replace may work but am wondering how would you guys write it.

Example the below may work but is it graceful or scalable.

TRIM(
REPLACE(

REPLACE(
REPLACE([Input],'3M','')

,'Nokia','')

,'Cisco',''))

[Felipe_Ribeir0]

Hi @zenSMP 

Here it is, with this expression you will be able to remove the first word of each row:

^(.*?)(?<=\s)

[Felipe_Ribeir0]

And with this one, you will be able to remove specific words, like 3M/Nokia/Cisco: