Hi
i have a text field separate by semicolon, for example

word1;word2;word3;word4;word5

and i want a custom formula field for each word, for example

field A  populated by word1
field B  populated by word2
field C  populated by word3
field D  populated by word4
field E  populated by word5

i have these formula, but only works with one semicolon
LEFT(textfield__c, (FIND(",", textfield__c)-1))

RIGHT(textfield__c, (LEN(textfield__c) – FIND(",", textfield__c)))


Thanks for your help