Making fields null that contain 3 letters

[furlonla]

Hi,

I am try to make fields nulls or blank which contain 3 letters (currency code). Is there any way to do this, please see screenshot of sample data attached.

Current Input

BankDebt-GT110 VALE - GS1VALE (272930)
EUR	Opening Balance (Settle Date)
GBP	Opening Balance (Settle Date)

Desired Output

BankDebt-GT110 VALE - GS1VALE (272930)
	Opening Balance (Settle Date)
	Opening Balance (Settle Date)

Thanks,

Laura

[BS_THE_ANALYST]

@furlonla here's one way:

Making use of the Length function. If Length of string = 3, then replace with null, else, keep existing value:

You can edit the length logic to whatever you like i.e. if length <= 3 then null etc.

Thanks,
BS

[binuacs]

@furlonla Another method using multi-row formula