Replace values with conditions

[Anonymous]

Hi,

I have a column containing visit names.

If the visit name is Adverse Event then I would like to remove the numbers and brackets that follow it. 

However, if the visit name is Ad Hoc i need to keep the numbers and brackets that follow it.

See below:

Any quick fixes?

Best,

Soph

[AbbasG · Accepted solution]

@Anonymous one way of doing it is through a conditional column as below. Hope it help's