i have 1 text field. the field format will be "Target XXXXX X". the question is , how can i get the "XXXXX X" value from my text field to my formula ( text) field.

Example 1 : "Target Kindergarten 1" -> "Kindergarten 1" (formula field) Example 2 : "Target Grade 1" -> "Grade 1" (formula field)

i try using RIGHT(field__c,FIND(" ",field__c)) in my formula but it only read the first space from the right and outcome will be "1". How can i get the second space from left so the output will be "Kindergarten 1"

1 Answer 1


You can take help from SUBSTITUTE(text, old_text, new_text) function . for example

TRIM( SUBSTITUTE(Target Kindergarten 1, Target, '')); it will give you

Kindergarten 1 This code will only work if you have fixed text value Target.

  • Hi @Tushar, if i use SUBTITUTE function. it will be fixed text right ? the whole text value must be "Target Kindergarten 1" or only "Target" must be fixed Oct 15, 2015 at 8:00
  • you can bind your field here Oct 15, 2015 at 8:12

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .