I have another field which needs to populate everything from the VAT registration Number except for the prefix. My attempt was:
IF( ISBLANK( VAT_Number_Start__c ),"",
SUBSTITUTE( VAT_Number_Start__c, VAT_Number_Start__c,
RIGHT( VAT_Number_Start__c,
LEN( VAT_Number_Start__c)-2 )
)
)
Although the syntax is correct it doesnt seem to work. Any help greatly appreciated
7 Antworten
Hi Tom,
you can go with below formula -IF( VAT_REG_Number__C != null, RIGHT(VAT_REG_Number__c , LEN(VAT_REG_Number__cr__c)-2), '')
- I am considiring, except 2 digit Prifix any number of digits.
- If your VAT field will be blank then your formula will also be blank.
Thanks,
Raj
